End of month date / Formula

Hi team,
hope everything is great on your side,
we have encountered a situation where we are trying to find a solution for a recurring activity which must be on the End of each month.
looking for this formula we expected to see this option.
what do you think?
we would really appreciate your attention on this one.

Dor
CloudZone

@Dorle

Are you just wanting a formula for the end of the current month?

If so, here you go:

FORMAT_DATE(EOMONTH(TODAY(),0))

Jim - Subscribe to The Monday Man
Watch Our Latest Video: A Killer Combo: monday.com, Integromat & Google Sheets - Recurring Tasks Example

1 Like

This formula is great, how do I convert it automatically to a date column versus being a formula column so automations can recognize it as a date?

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

@AK43040

The primary way to do this currently is to use Make (or similar) OR General Caster.

You can find out more about Make here: What is Make & How can it help you with monday?
For General Caster, look to the monday app marketplace.


Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards

We Create Custom Solutions
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)

1 Like