New Member
June 30, 2017
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?
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
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
1 Guest(s)