Forum Discussion
franklad
Jun 28, 2019Copper Contributor
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?
Twifoo
Jun 28, 2019Silver Contributor
Try this:
=DAY(DATE(Year,Month,22)-
WEEKDAY(DATE(Year,Month,1)-4))
=DAY(DATE(Year,Month,22)-
WEEKDAY(DATE(Year,Month,1)-4))