Calculate End Date from "Start Date Plus Number of Days (calculated and rounded up via formula)"
I'm trying to calculate End dates based off of a hard Start date, and adding a number of Days that I have listed in another cell.
The number of Days is calculated via formula, from one cell that lists Project hours (which I manually input) and each project is assigned to a crew, which have different amounts of hours that can be produced each day (i.e 2 man crew for an 8 hour day = 16 hours produced a day, 3 man crew = 24 etc...) which I then have "Rounded Up" in another column, because for us anything over one day (i.e. 1.25 days) is actually going to take "2" days.
In order to calculate the End date, my Crew Days need to be added to the Start Date. Because Crew Days are calculated via formula, it seems to prevent me from making the column properties a "duration" and therefore adding those days to the Start date.
Is there anyone out there that can offer a solution? I might be just going about this in the wrong order... or perhaps I need to combine formulas?
Screen shot also attached for reference!
Help Article Resources
Check out the Formula Handbook template!