Nth Day Of Week For A Month

G

Guest

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

Guest

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

Niek Otten

I don't understand your example, but look at this page at Chip Pearson's site:

http://www.cpearson.com/excel/DateTimeWS.htm#NthDoWYear

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nth weekday of the the month date problem 1
How to find the Day of week in a Month 1
Nth day of month of year 3
get week day of a date 2
Fiscal Year Week Number Calculation with a twist.... 6
Colouring cells based on day of week? 5
Formula to tell day of week 2
How do I setup recurring monthly task to occur on the nth working 1

Top