# Calculating Quarters from a date column

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!!

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

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

• 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))))))

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!