enter image description here

I want to load End Date field as start date field +2 years when user enter start date. this is a new form of my list.


This requirement can be handle using Content Editor WebPart or Script Editor WebPart.

You can edit the NewForm.aspx and add the CEWP/SEWP and handle the change event for the StartDate control. And based on this you can manage your EndDate control.

Similar post is shown Auto-Populate the Field Values Based on Text Change in SharePoint Online List Forms.

  • i want to populate based on one field in the same form/list. – Akul Jul 20 '16 at 11:43
  • In that case can't you use Calculated Field shown by @Milad? – Aakash Maurya Jul 20 '16 at 11:50
  • in calculated field list will be updated only, but i want to populate on the form at the time of filling – Akul Jul 20 '16 at 12:18
  • What you want is Auto populate the EndDate based on StartDate as soon as you select StartDate right? – Aakash Maurya Jul 20 '16 at 12:25
  • yes yes rightly said. – Akul Jul 20 '16 at 13:21

try this

and use a Calculated Field

=DATE(YEAR([Start Date])+2,MONTH([Start Date]),DAY([Start Date]))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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