Date Formula help
(i.e., 2/29/08 minus 2/23/08 = 5 )
The correct result is 6.
A1 = 2/23/2008
B1 = 2/29/2008
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<7))
--
Biff
Microsoft Excel MVP
"Di" <Di @discussions.microsoft.com wrote in message
...
I am trying to calculate the number of days in a time period excluding
Sundays,
(i.e., 2/29/08 minus 2/23/08 = 5 )
Can anyone help me?
Thanks
|