0

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

2

Instead of creating a date & time column with Today's date as default value, create a calculated column directly using below formula:

=DATEDIF([Start Date], TODAY(), "Y")

Output:

enter image description here

Documentation: Calculated Field Formulas

Useful thread: How to use Today and Me in Calculated column

Note:

  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
1
  • 1
    You just saved me! Thank you so much Ganesh!
    – BeerusDev
    Sep 22 at 14:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.