SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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 '13 at 13:42
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 '13 at 13:56
I just tested this and can confirm you're correct. Very interesting. – Stuart Pegg Feb 4 '13 at 14:27

Your Answer


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.