Formula, Blank Cell

Solved/Closed
Andyman123
Posts
2
Registration date
Monday March 16, 2015
Status
Member
Last seen
March 17, 2015
- Mar 16, 2015 at 10:48 PM
MaxStart
Posts
340
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
- Mar 17, 2015 at 12:57 AM
Sorry in advance if this has been asked but I can't see anything. Excel 2010

I have a cell that will contain a date then the next adjacent cell the same date plus 1 year then the next adjacent will highlight the year plus 1 minus two weeks (like an expiry warning). I started well with the date and date plus 1 but tried to add in if blank function i.e. if no date appears in first cell then second cell should be blank.

C2 is the date cell D2 is the date plus 1 and E2 is the same as D2 minus 14 days.

This is as far as I got for the formula in D2 =IF(C2="","",C2=DATE(YEAR(C2)+1,MONTH(C2),DAY(C2)))
This works with the blank C2 but when a date is entered D2 changes from blank to FALSE and I'm too much of a beginner to figure out why.

Thanks in advance,

Andy

1 reply

MaxStart
Posts
340
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Mar 17, 2015 at 12:20 AM
=IF(C2="","",DATE(YEAR(C2)+1,MONTH(C2),DAY(C2)))
1
Andyman123
Posts
2
Registration date
Monday March 16, 2015
Status
Member
Last seen
March 17, 2015

Mar 17, 2015 at 12:42 AM
Max thank-you - I've taken out the plus 1 for the month and day and it works fine for my need - sorry if I'm a bit slow with this
0
MaxStart
Posts
340
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Mar 17, 2015 at 12:57 AM
glad to be at service.
0