Forum Discussion
Dates
Hello, i need to format a cell. i have a column that has employee start dates in & then in the other Cell i would like it to 'calculate time with the company', so almost like a live update so that each time i go into the spreadsheet the 'Time with the company' has updated by a day. hope this makes sense
6 Replies
Hi Sabby02 you can use Today() function and do calculation on it. Today function take current date
Time with the Company(Days): =TODAY()-Start date cell value
Time with the Company(years): =(TODAY()-Start date cell value)/365
I hope it help you
Regards
https://www.upwork.com/freelancers/~01cf0fc8446b00f44c
=DATEDIF(A2,TODAY(),"d")
If the employee start dates are in range A2:A100 you can enter this formula in cell B2 and fill it down to cell B100.
- Thank you, would about time with company in months?
=DATEDIF(A2,TODAY(),"m")
You can use "m" for months. Here is further information about DATEDIF.
