12-month mark and 18-month mark formula
I have a column that has staff's date of hire. I have built columns for their 12-month mark and their 18-month mark but I am stumped on the formula to pull the date for the 12-month and 18-month mark. Can someone help!
Best Answer
-
One option is to add days to the Hire date:
12 months: =[Date Hired]@row + 365
18 months: =[Date Hired]@row + 547.5
Hope this helps!
Answers
-
One option is to add days to the Hire date:
12 months: =[Date Hired]@row + 365
18 months: =[Date Hired]@row + 547.5
Hope this helps!
-
@ker9 Thank you so much! That worked!
-
Your welcome! Does not account for Leap Years, which have 366 days.
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!
