Skip to main content
Question

The earning period runs for three months. How do I create a formula to result in date of the last day of month?

  • April 22, 2019
  • 0 replies
  • 29 views

I have an 'Earning Period Start' date field and an 'Earning Period End' formula-date field. The earning period runs for three months. How do I create a formula for a three month earning period that results in the last day of the third month? (i.e. Earning Period Starts 1/1/2019, Earning Period ends 3/31/2019). This is the formula I started with but it gives me the date of the first day of the third month, not the last day: 

=AdjustMonth([Earning Period Start],3)
This topic has been closed for replies.

  • Quickbase Alumni
  • April 22, 2019
To get the last day of any month, I would subtract 1 day from the 1st of the next month. Hope that helps.

or else

LastDayOfMonth(AdjustMonth([Earning Period Start],3))

  • Author
  • Quickbase Alumni
  • April 22, 2019
Thanks! This worked: AdjustMonth([Earning Period Start],3)-Days(1)