recurring day of a month

[ThedoreHolley]

I'm trying to figure a formula that changes the date based of the month. I.e. I'm Using the today formula and need specific column to be the 25th of each month. So today is the 11th and the event is happening on the 25th. can I have a formula that changes as today changes.

 

[Joe4]

Do you just want the 25th day of whatever the current month is?
If so, then try:

=DATE(YEAR(TODAY()),MONTH(TODAY()),25)

 

[ThedoreHolley]

I think that works

 

[Rick Rothstein]

You can also calculate the 25th of the current month this way...

=TODAY()-DAY(TODAY())+25

 

[Tetra201]

Or even shorter:

=EOMONTH(TODAY(),-1)+25

 

[ThedoreHolley]

What if I need just the day like last Tuesday of the month.

 

[Tetra201]

For the last Tuesday of the current month, try

=EOMONTH(TODAY(),0)-WEEKDAY(EOMONTH(TODAY(),0),2)+2

 

[Rick Rothstein]

For the last Tuesday of the current month, try

=EOMONTH(TODAY(),0)-WEEKDAY(EOMONTH(TODAY(),0),2)+2

I think this formula will not work correctly all the time. I think if the "today" date were any date in February 2016, it will return a date in March as the last Tuesday.

 

[Tetra201]

Rick,

Thank you for catching this. Actually, that formula errs whenever the 1st of the next month is a Tuesday.

Here is a new formula, with fewer function calls:

=WORKDAY.INTL(EOMONTH(TODAY(),0)+1,-1,"1011111")

 

[ThedoreHolley]

Thanks you guys are awesome