does excel have a formula to calculate the return the day number for a condition such as the 1st Mon

Highlighted
Occasional Visitor

hi

I'm trying to get the day number (1-31,etc) on a spreadsheet corresponding to the third Wednesday in a particular month. Is this possible or do I just do it manually?

2 Replies
Highlighted

Hello @franklad,

 

 Use this formula:

=DATE(y,m,22)-WEEKDAY(DATE(y,m,4))

 

Fill in y with the year and m with the month and format the cell as Custom Type: dd

 

Hope this helps!

PReagan

Try this:
=DAY(DATE(Year,Month,22)-
WEEKDAY(DATE(Year,Month,1)-4))