I'm trying to create a column in SharePoint that will calculate a destroy date based on an employees termination date.

Hanes, Tereasa 0 Reputation points
2023-03-03T18:55:29.8166667+00:00

I've tried various formulas and can't get anything to work. I want to calculate a destruction date based off of an employees termination date + 10 years. I've researched a number of sites and have tried all the different formulas but nothing is working. Does anyone have any ideas that might help me out?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,074 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Yanli Jiang - MSFT 23,036 Reputation points Microsoft Vendor
    2023-03-06T07:18:49.6733333+00:00

    Hi @Hanes, Tereasa ,

    You can use the below formula for destroy date column:

    =DATE(YEAR([employees termination date])+10,MONTH([employees termination date]),DAY([employees termination date]))

    03061

    And the result:

    03062


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thre


  2. Hanes, Tereasa 0 Reputation points
    2023-03-07T23:20:19.82+00:00

    This didn't work. I'm still receiving the same error message