Years in Service Formula
Good Day,
We are struggling with getting a "Years in service" calculator to work, after having pulled all the formulas that could be found by previous posts, still no luck.
=IF(AND(MONTH([Start Date]1) >= MONTH(TODAY()), DAY([Start Date]1) > DAY(TODAY())), YEAR(TODAY()) - 1 - YEAR([Start Date]1), YEAR(TODAY()) - YEAR([Start Date]1))
This is a copy and paste from another post, which it appeared had worked for them.
Dates are formatted as 8/2/2017, have tried 08/02/2017
But I consistently get Β #INVALIDDATATYPE
Any suggestions would be greatly appreciated.
Robert
Β
Β
Β
Β
Β
Comments
-
It sounds like your Start Date column might be set to Text/Number instead of Date.
-
Brian,
This was a "if it was a snake it would have bit me" sort of scenario.
Thank you for your help, it got where I needed to be. Very much appreciated.Robert
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!