Dates in This year
Options
Does anyone know how to do a countifs formula for dates that are in this year. I have a start date field MM/DD/YYYY and I want to count all that are in year 2022. Thank you!
Answers
-
@Lauren Smith You can use the YEAR function within the COUNTIFS:
=COUNTIFS([Start Date]:[Start Date], YEAR(@cell) = 2022)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!