Help on Dates

[Paulf]

Hiya

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

Thanks in advance
Paul

 

[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)

 

[Guest]

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]

Many Thanks Roger!

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

 

[Paulf]

Thanks Ron, appriciated

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