Hopefully you can help me please.
I need to add either 90 days or 180 days to a date (for this example say this date is in cell A2).
Whether I add 90 or 180 days depends on the value of another cell in the row (in say A1) eg: if A1=1, I need to +90 days to the date in A2; if A1=2, I need to +180 days to the date in A2.
I want the answer to this to be given in cell A3
I’ve formatted the cells A2 & A3 into date format. And I know that to +90 (or 180) days I just need to do =A2+90 (or 180)
I’ve also found out that to ignore cells without a date I need to use:
It’s the either or part that I can’t figure out.
Any help would be greatly appreciated