Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Calculating/adding anniversaries with date functions
Good morning, hoping someone can help out with this.
I'm trying to create a formula using hire date and today's date to calculate the number of years working for a company. For example, if someone was hired October 12, 2019, I would like to have a "years with company" automate to "2" and send a notification to my e-mail. Is there any possible way to do this?
Thanks,
Dan
Best Answers
-
Hi @Dan Tanner
Hope you are fine, you can add 2 columns :
1- Date column type call it [hire date].
2- Text / Number column type call it [number of working years]
then use the following formula and convert it to column format formula to calculate how many year each employee complete:
=ROUNDDOWN((TODAY() - [hire date]@row) / 365, 0)
The following screenshot shows a sample
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Your welcome and i will be happy to help you any time, I will be grateful for your "Vote Up" or "Insightful"
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Dan Tanner
Hope you are fine, you can add 2 columns :
1- Date column type call it [hire date].
2- Text / Number column type call it [number of working years]
then use the following formula and convert it to column format formula to calculate how many year each employee complete:
=ROUNDDOWN((TODAY() - [hire date]@row) / 365, 0)
The following screenshot shows a sample
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Amazing. Thank you kindly.
-
Your welcome and i will be happy to help you any time, I will be grateful for your "Vote Up" or "Insightful"
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.4K Get Help
- 465 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.4K Ideas & Feature Requests
- 86 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I need a formula that populates the due date based on the date that its approved. I want the date to be at the end of each quarter
- I have a source sheet of different items, rolling out on different dates for different stores. I am creating a target sheet of a rollout of one specific item. I want the target sheet to list all the s…
- = "Not Started" if NO boxes checked = "In Progress" if SOME boxes are checked = "Complete" if ALL boxes are checked for the attached example I manually changed status based on checked boxes, but I'm h…