Help!!! I need to find the new date from two cells. One will always have a date but the other cell may be blank or may be entered. I need to add 90 days to whichever cell has the date.
Example:
|
(A)
1st REPORT COMPLETED |
(B)
2nd REPORT COMPLETED |
(C)
NEW REPORT DUE |
| 10/4/16 |
(A) will always have a date. (B) may not and if not, I need to add 90 days to (A). If (B) has a date, I need to add 90 days to (B). What is the formula?
Hi Suzzietoo
Assuming 10/4/16 is in cell A2 and (B) is in cell B2 then in cell C2 you can enter:
=IF(B2<>"",B2+90,A2+90)
Hope this helps.
Sunny
I tried that and I get a weird date that makes no sense. 3/30/00
My guess is both cell A2 and B2 are blanks and that is why the result is showing 3/30/00 i.e. 03/30/1900 (US date format)
You can use this formula to prevent the above from happening.
=IF(B2<>"",B2+90,IF(A2<>"",A2+90,""))
If you are still having the same problem, you can attach a sample file for us to have a look.
Hope this helps.
Sunny
