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

Question

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

Hanes, Tereasa 0

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?

Yanli Jiang - MSFT 31,571 Reputation points Microsoft External Staff

2023-03-06T04:36:18.67+00:00

We are currently doing some research on this issue, will let you know as soon as possible.

2 answers

Your answer

Yanli Jiang - MSFT 31,571 Reputation points Microsoft External Staff

2023-03-06T04:36:18.67+00:00

We are currently doing some research on this issue, will let you know as soon as possible.

Answer 1

Yanli Jiang - MSFT 31,571 Microsoft External Staff

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

Hanes, Tereasa 0 Reputation points

2023-03-07T19:31:03.02+00:00

This didn't work either! :( Here's the message I got:
Hanes, Tereasa 0 Reputation points

2023-03-07T19:31:46.3466667+00:00

Here is what I typed in: =DATE(YEAR([Separation Date])+10,MONTH([Separation Date]),DAY([Separation Date])))

Answer 2

Hanes, Tereasa 0

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

Yanli Jiang - MSFT 31,571 Reputation points Microsoft External Staff

2023-03-08T05:51:14.46+00:00

Hi ,

According to the formula you provided, I found that you have an extra closing parenthesis at the end, please delete it and try again.

Please note that the punctuation in the formula is all English punctuation.
Yanli Jiang - MSFT 31,571 Reputation points Microsoft External Staff

2023-03-10T07:30:14.1333333+00:00

I am looking forward to your feedback if there is any update.

Please remember to update this thread if you have any progress.

Thank you for your understanding.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Yanli Jiang - MSFT 31,571 Reputation points Microsoft External Staff

2023-03-24T09:47:53.46+00:00

Is there any progress on this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Yanli Jiang - MSFT 31,571 Reputation points Microsoft External Staff

2023-04-04T09:57:35.53+00:00

Would you please provide us with an update on the status of your issue? I am checking to see if the problem has been resolved. Please let us know if you would like further assistance.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Share via

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

2 answers

Your answer