Hey peeps,
I am looking for a dynamic formula that returns the 3rd Monday in February based on a year value.
I am usingWhere A1= the year value.
=DATE($A$1,2,25)-WEEKDAY(DATE($A$1,2,2))
This formula works perfectly, except when the 1st of February is on a Monday, then it returns the 4th Monday of the month. What am I doing wrong?
Last edited by bl1nd; 01-10-2022 at 10:51 PM.
Try this
=WORKDAY.INTL(DATE($A$1,2,0),3,"0111111")
I don't understand your formula, but it works lol
Thank you!
One way
=DATE($A$1,2,22)-WEEKDAY(DATE($A$1,2,1),12)
Follow-up question, now need the last Monday preceding May 25 of the given year, but can't figure that one out either.
Gives me the day of the week that the 25th falls on, but how do I roll that back to the Monday before?=WEEKDAY(DATE($A$1,5,25))
=workday.intl(date($a$1,5,25),-1,"0111111")
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks