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?
Use this formula:
Fill in y with the year and m with the month and format the cell as Custom Type: dd
Hope this helps!