Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-728052%22%20slang%3D%22en-US%22%3Edoes%20excel%20have%20a%20formula%20to%20calculate%20the%20return%20the%20day%20number%20for%20a%20condition%20such%20as%20the%201st%20Mon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-728052%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%3C%2FP%3E%3CP%3EI'm%20trying%20to%20get%20the%20day%20number%20(1-31%2Cetc)%20on%20a%20spreadsheet%20corresponding%20to%20the%20third%20Wednesday%20in%20a%20particular%20month.%20Is%20this%20possible%20or%20do%20I%20just%20do%20it%20manually%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-728052%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-728123%22%20slang%3D%22en-US%22%3ERe%3A%20does%20excel%20have%20a%20formula%20to%20calculate%20the%20return%20the%20day%20number%20for%20a%20condition%20such%20as%20the%201st%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-728123%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368290%22%20target%3D%22_blank%22%3E%40franklad%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BUse%20this%20formula%3A%3C%2FP%3E%3CP%3E%3DDATE(y%2Cm%2C22)-WEEKDAY(DATE(y%2Cm%2C4))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFill%20in%20y%20with%20the%20year%20and%20m%20with%20the%20month%20and%20format%20the%20cell%20as%20Custom%20Type%3A%20dd%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3C%2FP%3E%3CP%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-728168%22%20slang%3D%22en-US%22%3ERe%3A%20does%20excel%20have%20a%20formula%20to%20calculate%20the%20return%20the%20day%20number%20for%20a%20condition%20such%20as%20the%201st%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-728168%22%20slang%3D%22en-US%22%3ETry%20this%3A%3CBR%20%2F%3E%3DDAY(DATE(Year%2CMonth%2C22)-%3CBR%20%2F%3EWEEKDAY(DATE(Year%2CMonth%2C1)-4))%3C%2FLINGO-BODY%3E
franklad
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

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