Help on Dates

P

Paulf

Hiya

Is there a way of calculating the number of Saturdays between two dates in
Excel?

Thanks in advance
Paul
 
R

Roger Govier

Hi Paul
With start date in A1 and end date in B1 try
=INT((B1-A1)/7)+OR(WEEKDAY(A1)=7,WEEKDAY(B1)=7)
 
R

Ron Coderre

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
 
P

Paulf

Thanks Ron, appriciated

Ron Coderre said:
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
Click to expand...
 
Top