I have a field called "Onboarding Date" which is a Date & Time field.
I want to create a new field called "RetentionDate" which will be a date 1 year later than the users input in the Onboarding Date column
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityCreate a new calculated column & use formula in below format:
=DATE(YEAR([Onboarding Date]) + 1, MONTH([Onboarding Date]), DAY([Onboarding Date]))
Documentation: Calculated Field Formulas - Date and time formulas
Note: Sometimes comma(,
) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;
) instead of comma(,
).