I have a column StartDate
and I want to calculate the time difference in years from that date to the current day. For example:
My start date of work is 4/19/2016, it will be 5 years until 4/19/2022 then it will calculate 6 years. How can I achieve this?
I have tried the following:
Created a Today Date & Time Column, where the default value is Today's Date.
Created a YearsHere
Column, that has the following calculated value:
DATEDIF([Start Date],[Today],"Y")
And it returns something like, 108. Say the Start Date is 6/22/2020, the YearsHere
column will show 120? Why is that.
UPDATE:
So, the today column is empty. Is there a workaround