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 8,446 Reputation points Microsoft Vendor

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.

Yanli Jiang - MSFT 8,446 Reputation points Microsoft Vendor

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 8,446 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]))

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 8,446 Reputation points Microsoft Vendor

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 8,446 Reputation points Microsoft Vendor

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.
Yanli Jiang - MSFT 8,446 Reputation points Microsoft Vendor

2023-03-17T08:59:28.8833333+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.
Yanli Jiang - MSFT 8,446 Reputation points Microsoft Vendor

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.

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

2 answers

Activity