|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How do I calculate a difference in work days?
"M" wrote:
HI,
I need a formula to calculate the work days between 2 days, based on a
parameter. so if its 1 then the workdays formula works, but if its 2 then
only Sunday is a holiday. any suggestions?
also i want work days for each month from start date to end date.
-M
"Peo Sjoblom" wrote:
Look in help for NETWORKDAYS, it's part of ATP which comes with Excel
--
Regards,
Peo Sjoblom
"Work Days" <Work wrote in message
...
I have created a spreadsheet in which there is a committed ship date as
opposed to the actual ship date. However, I need this calculated
difference
to be in work days. Does anyone have a formula for this?
Hi,
The help function for workdays does not say anything about calculating work
days that includes Saturday as a work day.
-M
|