# Amount of Days in Quarter

Options
Member

Hi,

I'm trying to create a formula to count the total amount of days in the current quarter. Seems pretty simple, but can't seem to figure it out.

Any suggestions?

• Member
Options

I figured it out on my own using the below formula

(CASE
WHEN QUARTER(NOW()) = 1 AND MOD(YEAR(NOW()), 4) = 0 THEN 91 /* First quarter leap year */
WHEN QUARTER(NOW()) = 1 AND MOD(YEAR(NOW()), 4) != 0 THEN 90 /* First quarter not leap year */
WHEN QUARTER(NOW()) = 2 THEN 91 /* Second quarter */
WHEN QUARTER(NOW()) = 3 THEN 92 /* Third quarter */
WHEN QUARTER(NOW()) = 4 THEN 92 /* Fourth quarter */
END)

• Member
Options

I figured it out on my own using the below formula

(CASE
WHEN QUARTER(NOW()) = 1 AND MOD(YEAR(NOW()), 4) = 0 THEN 91 /* First quarter leap year */
WHEN QUARTER(NOW()) = 1 AND MOD(YEAR(NOW()), 4) != 0 THEN 90 /* First quarter not leap year */
WHEN QUARTER(NOW()) = 2 THEN 91 /* Second quarter */
WHEN QUARTER(NOW()) = 3 THEN 92 /* Third quarter */
WHEN QUARTER(NOW()) = 4 THEN 92 /* Fourth quarter */
END)