I need help creating an excel spreadsheet or workbook that incorporates a formula using dates and dynamically produces an answer when provided with a few inputs.
Context: I can create a "widget", but I have to wait for the current rotation to be over before I can submit the widget. The rotations have a set schedule, which I can provide.
I need the excel spreadsheet to produce an answer in 2 different ways.
First Variation (working forwards)
Inputs
(1) # of Days worth of work
(2) # of people who can help (to cut down time)
(3) date that i can start work
---> Output = which rotation (date) can i hit?
Second Variation (working backwards)
(1) i need to hit this rotation - date
(2) # of days worth of work
(3) # of people who can help (to cut down time)
---> Output = when do i need to start working
All days must only be business days (no holidays/weekends)
And the dates that come out must go to the next rotation...
I've looked at goal seeker and what-if analysis and couldn't figure out how to make this work... pls help! thanks!!!
Context: I can create a "widget", but I have to wait for the current rotation to be over before I can submit the widget. The rotations have a set schedule, which I can provide.
I need the excel spreadsheet to produce an answer in 2 different ways.
First Variation (working forwards)
Inputs
(1) # of Days worth of work
(2) # of people who can help (to cut down time)
(3) date that i can start work
---> Output = which rotation (date) can i hit?
Second Variation (working backwards)
(1) i need to hit this rotation - date
(2) # of days worth of work
(3) # of people who can help (to cut down time)
---> Output = when do i need to start working
All days must only be business days (no holidays/weekends)
And the dates that come out must go to the next rotation...
I've looked at goal seeker and what-if analysis and couldn't figure out how to make this work... pls help! thanks!!!
