Thanks Michael,

But I am not getting exactly how to find the total no. of weekdays in that year using the 'Tally' table. Can you please explain some what more?

It would be better if i can have a function which will accept StartDate, EndDate and the ClientDate parameters so that if the day of 'ClientDate' was say 'Tuesday', we should get to know the total no. of Tuesdays in that year from the StartDate till end of the year.

Thanks,

Bhakti