Hi y'all,
I need to calculate a date from now based on the pre-defined "production capacity".
User manually adds info (cells C3, E3, G3 for example) and based on the information from those cells and predefined production capacity (K 3, K4 - N3. N4), the deadline should appear in cells in column E (Step 1).
Additionally, the deadlines can only be calculated from hours 8:30 till 17 (L8, N8).
Then, Step 2 deadline (col F) should add time defined in M11, then Step 3 (col G) - from M12.
Deadline H column can be ignored.
Anybody up for this challenge...?
Thank you all in advance for checking and asking if I missed any important information!
Bookmarks