Help on Dates
 

Hiya

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

Thanks in advance
Paul

Help on Dates
 

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

--
Regards

Roger Govier


"Paulf" wrote in message
...
Hiya

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

Thanks in advance
Paul

Help on Dates
 

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

Help on Dates
 

Many Thanks Roger!

"Roger Govier" wrote in message
...
Hi Paul
With start date in A1 and end date in B1 try
=INT((B1-A1)/7)+OR(WEEKDAY(A1)=7,WEEKDAY(B1)=7)

--
Regards

Roger Govier


"Paulf" wrote in message
...
Hiya

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

Thanks in advance
Paul

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