Formula Subtracting Business Days
In Call A1:
11/12/2007
In Cell A2:
11/1/2007
In Cell A3:
=NETWORKDAYS(A2,A1)
Result:
8
From Help:
NETWORKDAYS(start_date,end_date,holidays)
Regards,
Ryan---
--
RyGuy
"Erika" wrote:
I need to create a formula that will take a date that I have listed in my
spreadsheet and subtract from it the number of business days.
For example
Date in cell A1 11/12/2007
Number of Business days to subtract in A2 12
|