Subtract number of working days, from a date

[Rick__]

Hi all,

You've all been so helpful in the past, so I thought you might be able to help me out once again.

I'm trying to work out lead times based on a cut off date, I need to subtract the lead time (Column B) from the cut off (Column C) to calcualte the last order date (Column D), however I need to make sure the fourmula only counts work days (Mon - Fri).

Bascially "Last Order Date" = "Cut off" - Lead Time (not counting weekdays).


Thank you in advance.

	A	B	C	D
1	Product	Lead Time (in days)	Cut off	Last Order Date
2	Phone Case	8	18/12/2018	?
3	Charger	5	18/12/2018	?

<tbody>
</tbody>

 

[kvngrn]

Hi,

Try

=WORKDAY(C2,-B2)

 

[Rick__]

Thats worked perfectly thank you kvngrn

 

[Peter_SSs]

Note also that you can build any known holidays into this. For example:

Excel Workbook
	B	C	D	E	F
1	Lead	Cut Off	Last order		Holidays
2	3	16/03/2018	12/03/2018		1/01/2018
3					15/03/2018
Subtract Work Days