Working days

[Necro]

Hi all,
Couldnt wrap my head around solving this issue today:

I want to calculate when to start producing a work order to meet a date. And the time it will take to build it, will have an index of hours.

Ex:
A date for the order to be ready is 2022-05-16
Time to build is 70 hours=8.75 days.
Now I need the date to find which date the order needs to start to meet deadline, excluding weekends since none is working then.
2022-05-16 minus 8,75 (9 working days) = 2022-05-03


Thanks!

 

[Eric W]

How about:

Book1
	A	B	C
1	Date	Hours	Start Date
2	5/16/2022	70	5/3/2022
End

Cell Formulas
Range	Formula
C2	C2	=WORKDAY(A2,-B2/8)

You can add a holiday range to that function too.

 

[Necro]

How about:

Book1
	A	B	C
1	Date	Hours	Start Date
2	5/16/2022	70	5/3/2022
End

Cell Formulas
Range	Formula
C2	C2	=WORKDAY(A2,-B2/8)

You can add a holiday range to that function too.

Amazing, and ridicolous by me. Thought I tried this at work already but seems not, unless there is some glitch setting in the office...
A huge thank you!

 

[Eric W]

Glad I could help! Thanks for the feedback. ?

 

[Necro]

Glad I could help! Thanks for the feedback. ?

Also!
Is there a way that you know of to make the following formula work with workdays instead of days?
=days(J10;B2)/((R10+S10)/8)

 

[Eric W]

If B2 is before J10, then

=NETWORKDAYS(B2,J10)/((R10+S10)/8)

 

[Necro]

If B2 is before J10, then

=NETWORKDAYS(B2,J10)/((R10+S10)/8)

Simplicity in its finest. Thank you so much!