List of date formula I have used repeatedly

2»

Comments

  • Returns either "Prior Quarter", "Current Quarter", "Next Quarter" or "Future Quarter" for a date column on your sheet. For this example my column name was [Go-Live].


    =IF(OR(YEAR([Go-Live]@row) < YEAR(TODAY()), AND(YEAR([Go-Live]@row) = YEAR(TODAY()), ROUNDUP(MONTH([Go-Live]@row) / 3, 0) < ROUNDUP(MONTH(TODAY()) / 3, 0))), "Prior Quarter", IF(AND(YEAR([Go-Live]@row) = YEAR(TODAY()), ROUNDUP(MONTH([Go-Live]@row) / 3, 0) = ROUNDUP(MONTH(TODAY()) / 3, 0)), "Current Quarter", IF(AND(YEAR([Go-Live]@row) = YEAR(TODAY()), ROUNDUP(MONTH([Go-Live]@row) / 3, 0) = (ROUNDUP(MONTH(TODAY()) / 3, 0)) + 1), "Next Quarter", "Future Quarter")))