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?

1 Answer 1


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, 2021 at 5:16
  • Hi @ekoz, Can 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. Dec 7, 2021 at 12:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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