How to modify a date from a value

[Maricela17]

Hello team
I need your help... I have a formula that tells me the last day of each month, but I need to create another column that tells me that if the month ends on the 31st, subtract a day and leave the 30th. That is, I need every month to end on the 30th.

Thank you

[Pilsner]

Hello @Maricela17 

If you are looking to create a column called end of month, which contains 30th of each month, you could use the following logic.

 

This takes the year and month from the date column, then appends a "-30" onto the end, forcing the date to be the 30th of the month. 

I have attached the workflow below. Please let me know if this achieves the output you expected.

Regards - Pilsner

[binuacs]

@Maricela17 one way of doing this

[Maricela17]

Hello, thank you very much.

What I really need is, for example, if the "Days" column ends on the 31st, subtract one day so that the final date is 30. If it doesn't end on the 31st, leave the original date.

Thank you so much

[binuacs · Accepted solution]

@Maricela17 update the formula like below

[Pilsner · Accepted solution]

Hello @Maricela17 

Here is a revised version, which should only change dates that are actually on the 31st.

 

[Maricela17]

It worked perfectly, thank you very much.