Count Sunday & Saturday between two days.

[kashif.special2005]

Hi

I have table named Date and there is three columns Start_Date, End Date and Count_Sunday_Saturday.

I want to count how may Sunday and Saturday between Date1 and Date2.

date1	date2	Except_Sunday_Saturday
1/1/2012	1/25/2012

I am not able to do this.

Please help it is very important.

Thanks & Regards,
Kashif.

[June7]

Why does the example field name say 'Except_Sunday_Saturday'?

Looking at a calendar I see 4 Sundays (including 1/1/2012) and 3 Saturdays between those dates. That's what you want for results?

EDIT: Wow, pbaldy, simple and sweet! The functions from link in next post work great.

[RuralGuy]

This link should be helpful: http://access.mvps.org/access/datetime/date0011.htm