What i exactly wanted is:

If the StartDate is say '7/15/2007', EndDate is '8/20/2009' and the ClientDate is say '9/12/2007' (the day is Wednesday on 12 Sept) then i need to...

Hi All,

thanks a lot for all your help. I created one function for this which will calculate the total no. of Mondays or Tuesdays... etc.

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