Formula

[Mslagofduty]

I have a drop down menu in a spreadsheet for frequency. I’m trying to calculate for the 3rd Wednesday of the month bc that’s when I receive a certain income. How would I go about this?!

[#2]

Hi,

The date of 3rd Wednesday of a month depends on the last day of the previous month:

If the last day of the previous month was Sunday, 3rd Wednesday of this month is 17th. Likewise,

Monday - 16th

Tuesday - 15th

Wednesday - 21st

Thursday - 20th

Friday - 19th

Saturday - 18th

So, here's a simple formula to calculate the date of 3rd Wednesday of the month:

=CHOOSE(WEEKDAY(EOMONTH(TODAY(),-1)),17,16,15,21,20,19,18)

(Replace "TODAY()" with an appropriate date as needed.)

Hope this works!