I am struggling writing the formula for SharePoint calculated column.

I have 3 SharePoint Columns:

[Vaccination date];
[Infected] - Yes/No choice;
[No testing is not needed (date)]

In column [No testing is not needed (date)] I would like to calculate the date a person does not need to get tested, which means I would like to add 14 days to the [Vaccination date] if the person was infected.

I have been using the following formula:

=IF([Infected]="Yes"; [Vaccination date] + 14; "")

This formula seems to work only when both columns are not blank. If one of the columns is not, then I get the default date "1900-01-13".

Any suggestions?


Try using this:

=IF(OR(ISBLANK([Infected]); ISBLANK([Vaccination date])); ""; IF([Infected] = "Yes"; [Vaccination date] + 14; ""))


Calculated Field Formulas

  • Thank you, worked perfectly!
    – ekoz
    Aug 19 at 5:16
  • Great, glad it worked for you. Please Upvote(^) and accept as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. It also removes this question from "Unanswered questions" list. Sep 2 at 16:10

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.