On Mon, 14 Jan 2008 07:59:04 -0800, Bhupinder Rayat
wrote:

Hi All,

I want to count the number of Saturdays between 2 specifed dates.

i.e. between 1 Jan 08 and 31 Jan 08 there are 4 Saturdays.

Can anyone help please?

Thanks,

B/


In General:

=INT((A2-WEEKDAY(A2+1-DOW)-A1+8)/7)

where A2 is the end date; A1 is the start date, and DOW is the day of the week
with 1=Sun

So for Saturdays:

=INT((A2-WEEKDAY(A2+1-7)-A1+8)/7)

--ron