Calculate no. of Sundays in a month
Hi Ron,
Thanx for the help. It was very helpful
"Ron Coderre" wrote:
Try this:
With Dates in A1:A10
This formula counts the number of Saturdays in that range:
=SUMPRODUCT(--(WEEKDAY(A1:A10)=7))
To count other days:
1=Sunday, 2=Monday,....7=Saturday
Does that help?
Post back if you have more questions.
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Arup C" wrote in message
...
Hi everybody,
Can we calculate no. of sundays from a given range of dates formatted as
"d
mmm yy ddd"
for example
1 Nov 07 Thu
2 Nov 07 Fri
3 Nov 07 Sat
4 Nov 07 Sun
and so on....
|