Find the last day of the following month

Ask for Help
41

I just threw this together quickly based on how I currently understand your goal.

So basically it’s 3 columns. An initial start date, which will only be set once and never change, and then a calculated current Start Date and a calculated current End Date.
image

  • Initial Start Date is just a date column. Nothing special about it.
  • mth-Start Date is calculated based on the current date.
    image
    image527×549 45.6 KB
  • mth-End Date just adds 30 days to that calculated start date.
    image

Let me know if I’m misunderstanding anything.

42

Awesome!
And so using your example, when the mth-EndDate is reached, will the mth-Start Date change, causing the mth-End Date to also change.

Using your first row of Initial Start Date of 1/1/23, the mth-End Date is 1/31/23. Once it becomes say 2/1/23, will the mth-Start Date change to become 2/1/23, causing the mth-End Date to then change to 3/2/23?

43

Obviously haven’t done extensive testing on this, but that appears to be the case.

image

44

Perfect! What took you a few minutes would have taken me forever. Thank you so much!

45

Double check my math. 30 days from Dec 17th is Jan 16th, which also becomes the start of a new cycle. I think the start date is a day early, but I want to make sure you agree.

46

If it is in fact a day early, then I think it’s just a small tweak to the formula. Be sure to throw some dates at it and test it to make sure you get the expected results.

image
image703×510 55.6 KB

47

Thanks, I’ll test it out and tweak as needed!