Dates formula
Thanks Roger. It worked.
"Roger Govier" wrote:
Hi
With 10/23/07 in A1 and 18/10/07 in B1
=NETWORKDAYS(B1,A1)-1
You need to deduct 1 if you want a result of 3, as Networkdays includes the
whole of the first and last days.
Networkdays is part of the Analysis Toolpak.
ToolsAddinscheck Analysis Toolpak
--
Regards
Roger Govier
"orquidea" wrote in message
...
Hi
I want to deduct 2 dates. I also want to deduct weekend days if they are
within the period of time of the calculation. e.i
10/23/07 - 10/18/07 = 5 days minus 2 weekend days = 3 days
I want to get 3 days result.
Could someone help with this formula please.
Thanks
Orquidea
|