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?
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
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: 57
Currently Online:
27 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
