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

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?

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

    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]))


    And the result:


    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

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