I'm glad I could help........and thanks for the feedback

***********
Regards,
Ron

XL2003, WinXP


"Arup C" wrote:

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