Hope you're well;
Can I have help with the following SharePoint list, I would like the expiry alert date column to automatically update to 6 months post the contract expiry date column;
Is possible to do . How do I do it.
kind regards, Anees
Here is a source for some syntax around calculated columns!
For your problem, you want to add 6 months contract expiry date. Here is the formula:
=DATE(YEAR([ContactExpiry Date]),MONTH([ContactExpiry Date])+6,DAY([ContactExpiry Date]))
Hope that helps!