Use our Google Custom Search for best site search results.
I need to add 2 years to a date field "D-SAACPCertificationDate" and display it in another field "D-SAACPExperationDate". I tried using the calculated field function in SharePoint Server list =DATE(YEAR([D-SAACPCertificationDate])+2,MONTH([D-SAACPCertificationDate]),DAY([D-SAACPCertificationDate])), but it errors. I tried several variations and breaking down into smaller parts. Any help will be appreciated. Thank you in advance
Thanks, the formula does work, I was putting it in the default value box instead of "The type of information in this column is:" section