Formula for finding the first and last days of a year
Comments
-
You don't really need to update anything other than the year right?
=date(year(today()),1,1) is the first day of the year
=date(year(today()),12,31) is the last day of the year
-
Correct,
Perfect, Thank you!
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!