ENDOFQUARTER formula

MarionCarrie

For modules building, it would be helpful to have a ENDOFQUARTER formula to identify the end of quarter date of a date.

Rnilsson

You could do 3 line items (Date, Period, End Date)
line item—-Format—————————Formula.
Date.———-Date. —————————-Start() ← Should already be in the model
Period ——-Time Period (quarter)—- period(Date.) ← Would probably already be in the model
End Date —-Date —————————-"end(period)"
but I agree it would be quicker with one command

Dikshant

@MarionCarrie,

ENDOFQUARTER(Date) =
IF MONTH(Date) <= 3 THEN DATE(YEAR(Date), 3, 31)
ELSEIF MONTH(Date) <= 6 THEN DATE(YEAR(Date), 6, 30)
ELSEIF MONTH(Date) <= 9 THEN DATE(YEAR(Date), 9, 30)
ELSE DATE(YEAR(Date), 12, 31)

This formula checks the month of the given date and returns the end of the corresponding quarter.

MarionCarrie

THANK YOU SO MUCH !