Compute Tenure date to TODAY
Hello-
Can you assist me with the formula for the # of years and month?
Hiring Date is Oct 17, 2002 === What is the years and months of Tenure
Best Answer
-
I'm so sorry! Can't believe I missed that step. This should do it:
- =ROUNDDOWN((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUNDDOWN((TODAY() - [Hiring Date]@row) / 30 - (ROUNDDOWN(((TODAY() - [Hiring Date]@row) / 30) / 12) * 12)) + "Months"
Best,
Zach Hall
Training Delivery Manager / Charter Communications
Answers
-
Hi,
Assuming you have a [Hiring Date] column you could use a formula like:
- =ROUND((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUND((TODAY()-[Hiring Date]@row)/30) + "Months"
This isn't exact as there are not 30 days in every month, but it gives you a close approximation. The formula to get the exact number of months would be slightly more complicated.
Hope this helps!
Best,
Zach Hall
Training Delivery Manager / Charter Communications
-
The result is 22 Years 271Months from your formula.... What I need is... for Oct 17, 2001 ---22 years 3 months Thanks.
-
I'm so sorry! Can't believe I missed that step. This should do it:
- =ROUNDDOWN((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUNDDOWN((TODAY() - [Hiring Date]@row) / 30 - (ROUNDDOWN(((TODAY() - [Hiring Date]@row) / 30) / 12) * 12)) + "Months"
Best,
Zach Hall
Training Delivery Manager / Charter Communications
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!