Look at the WEEKDAY function. It is available in both the worksheet and as a
VBA function.

"Vadhimoo" wrote:

Dear All,
Can you please help me, to find the "Nth day of Week for a Month" ?
For example, it will return 24-Sep-07 for the 5th of Sep, 2007.
Days-of-week range from 1 to 7, with Sunday = 1 and Saturday = 7

Thanks in advance for your reply.

Thanks and Regards,
Vadivelan Adhimoolam.