Excel expert needed for building spreadsheet to track jobs

I am looking for an Excel expert to help finish the Master Job Tracker spreadsheet I am building for my company. I have made the headings and have an explanation for what I want each cell to do. We are a court reporting company so we follow each job from the first stage of the reporter writing on her machine the job (transcript), the transcript then goes to a scopist (editor), then to a proofreader, then back to the reporter, and then to the office. You can see why we need to track them! What makes it complicated is there is different turnaround times to select from (5-8 day turnaround, 3-day, same-day). And what I would like to happen is after the job date is selected, the turnaround time, then I would like the Scoping Due Date and Proofing Due Date to auto populate to their respective dates. So for example: If Job Due Date is Monday, then Turnaround time selected is 5-8 days, then I would like Scoping Due Date to auto populate to noon 5 business days after the column Job Due Date. And then I would like Proofing Due Date to auto populate to noon 7 business days after Job Due Date.
Is this possible? I am uploading the initial documents I created, the Excel with column names and a Word document with more explanations about each column.
Thanks in advance!
About the recuiter
Member since Mar 14, 2020
David Crone
from Central, Uganda

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions