Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 2 down vote favorite

I have two columns in a list, one called 'start date' and one called 'renewal date' what I need is for the renewal date to default to a year after the start date, i.e. Start date = 07/09/2013 and for the renewal date to be 06/09/2014, if that makes sense?

The above dates are in the format dd/mm/yyyy. For clarity, please could you answer with dates in the same format.

share|improve this question

1 Answer

up vote 4 down vote

You can make a calculated column, formatted as Date and Time, with a formula like this:

=DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date]))
share|improve this answer
+1 But very occasionally you might get an error on leap years (e.g. 29/2/12 -> 29/2/13, which doesn't exist). – Stuart Pegg Feb 4 at 13:42
1  
As long as you're formatting the field as Date and Time, it will work out the leap year for you. So in your example, it would return 01/03/13 – Dodswm Feb 4 at 13:56
1  
I just tested this and can confirm you're correct. Very interesting. – Stuart Pegg Feb 4 at 14:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.