Excel formula help: I have a column of dates, and of "lead times": no. of days to be subtracted to produce a resulting date. However,
Posted by
con_carne
Jun 4 '09, 16:03
|
I need Excel to treat that amount of days as business days, not calendar days.
So right now, for example:
06/10/2009 minus 100 days equals 03/02/2009, but it should really produce something like 01/20/09 because that 100 is business days, not calendar days. See?
The formula NETWORKDAYS, which pulls work days from a company network, doesn't seem to work here.
Help?
|
Responses:
|