I am seeking assistance to fix a formula on my office vaccination records data sheet.
Each employee vaccination record dates are listed in Column A, B, & C. Some have not taken any dozes, while others have taken just one doze, and some all three dozes. Column E needs to reflect their last taken doze plus x number of months. In this case, I have listed 9 months. If that date is in the past, Column F should show is Expired. If the date is less than 9 months, it shows up as Valid.
To summarize this "IF Column D is not a blank, then, add 9 months to it in Column E. If it is a blank, then read Column C and add 9 months to it in Column E. "
Any help would be most appreciated.
Thank you.
Bookmarks