Register
Log In
Unanswered
Home
New Member
June 30, 2017
Offline
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
Dashboards
June 25, 2016
Offline 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
New Member
June 30, 2017
Offline I tried that and I get a weird date that makes no sense. 3/30/00
VIP
Dashboards
June 25, 2016
Offline 
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
Most Users Ever Online: 107
Currently Online: Catalin Bombea
10 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1303
Anders Sehlstedt: 341
Frans Visser: 322
David_Ng: 188
Velouria: 137
A.Maurizio: 124
Aye Mu: 115
Alison Banks: 109
Anne Walsh: 97
mymalone: 84
Newest Members:
Devender Chauhan
kendra hull
Percy Bukes
Fatou M
Ana Gomez
Shammy Somanna Hosoklu
Nichol Perez
Danny Rios
irem dagli
PeterK
Forum Stats:
Groups: 2
Forums: 22
Topics: 2594
Posts: 11650
Member Stats:
Guest Posters: 4
Members: 52278
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
