Forum Discussion
Sabby02
Aug 24, 2023Copper Contributor
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 ea...
leoperdia
Aug 24, 2023Brass Contributor
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