Forum Discussion

ElvirBotic's avatar
ElvirBotic
Helper III
3 years ago
Solved

Add Years to Date

Hello, I have a table with two columns. Column A is a Install Date and Column B is the life expectancy of that asset. Life expectancy is always X amount of years. I want to take the date an asset was...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, ElvirBotic ;

    You could also try .

    Replacement Date2 = EDATE([Install Date],[Life Expectancy (Years)]*12)

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, ElvirBotic ;

You could also try .

Replacement Date2 = EDATE([Install Date],[Life Expectancy (Years)]*12)

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.