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

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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No. of Saturdays between 2 dates 5
Calculating number of weeks between dates? 2
Number of Saturdays within a range of dates 4
Need number of Saturdays and number of Sundays between 2 dates 1
Need blank cells to remain empty 7
count work days excluding Fridays and Saturdays ??? 3
Difference - except for Saturdays and Sundays 10
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr 13

Top