Jun 28 2019 07:02 AM
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?
Jun 28 2019 07:35 AM
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
Jun 28 2019 07:56 AM