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.
11,229 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Yanli Jiang - MSFT 31,571 Reputation points Microsoft External Staff
    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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.