Help

Calculating the last day of the month for each quarter

Topic Labels: Formulas
1743 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michelle-T
4 - Data Explorer
4 - Data Explorer

I have a “Next Year End” date field for each of our clients and then I have fields for each of the 4 quarters to populate dates in various other tables. I am trying to create a formula that will take automatically choose the last day of the month when I use this formula:

DATEADD({Next Year End}, 6, “month”) - it basically brings me to October 30th, not October 31st.

Does anyone know what I’m missing? I’ve been looking everywhere in here…It doesn’t seem like this should be so difficult unless I’m totally not understanding :slightly_smiling_face:

Thanks in advance!

1 Reply 1

Hi @Michelle-T ,

I don’t see any other way except to return the month from this formula and then hardcode the date based on the month So basically you write down if the month is Jan Mar May etc. then 31 and if April June etc. 30 and if Feb 28