Previous Topic Next Topic

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 339 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 response

Answer 1 / 1
MaxStart Posts 339 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 339 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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Formula to Find&replace blank cells in excel
onetuff_z -
tstobb -

11 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses