Calculating Quarters from a date column

Vanessa White

I am trying to calculate the number of completed tasks per quarter. I can't figure out how to create a formula that will calculate this. Any help is greatly appreciated!!

Paul Newcome

Will you have a year overlap on your sheet, or will there only be entries for a single year?

Vanessa White

I really just want to show the total for the current quarter

Paul Newcome

Ok. Assuming you are using calendar year for the quarters, I would suggest something like this...

=COUNTIFS([Completed Date]:[Completed Date], AND(@cell < IF(TODAY() < DATE(YEAR(TODAY()), 4, 1), DATE(YEAR(TODAY()), 4, 1), IF(TODAY() < DATE(YEAR(TODAY()), 7, 1), DATE(YEAR(TODAY()), 7, 1), IF(TODAY() < DATE(YEAR(TODAY()), 10, 1), DATE(YEAR(TODAY()), 10, 1), DATE(YEAR(TODAY()), 12, 31)))), @cell >= IF(TODAY() < DATE(YEAR(TODAY()), 4, 1), DATE(YEAR(TODAY()), 1, 1), IF(TODAY() < DATE(YEAR(TODAY()), 7, 1), DATE(YEAR(TODAY()), 4, 1), IF(TODAY() < DATE(YEAR(TODAY()), 10, 1), DATE(YEAR(TODAY()), 7, 1), DATE(YEAR(TODAY()), 10, 31))))))

MegJF

What if I am trying to calculate the number of initiatives within a single quarter?