• 470K Members
• 6,320 Online
• 568K Conversations

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

Occasional Visitor

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

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

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

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

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

Try this:
=DAY(DATE(Year,Month,22)-
WEEKDAY(DATE(Year,Month,1)-4))
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies