Help on Dates
Thanks Ron, appriciated
"Ron Coderre" wrote in message
...
Try this:
With
A1: (the start date)
B1: (the end date)
This formula counts the number of Saturdays within that date range
C1: =SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,A1):INDEX(A:A,B1)))=7))
Note: 1=Sunday, 2=Monday.....7=Saturday
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Paulf" wrote:
Hiya
Is there a way of calculating the number of Saturdays between two dates
in
Excel?
Thanks in advance
Paul
|