Need formula to add days to a date in column unless blank then add days to another date.

[somfin4u2c]

I need a formula to add days to a column of dates unless blank then add days to the previous column.

I have 3 columns (A) Date Out, (B) Date Last Serviced, and (C) Service Due

I need to add 14 days to (B) Date Last Serviced to get (C) Service Due This formula works fine for this =IF(ISNUMBER(B4), DATE(YEAR(B4),MONTH(B4),DAY(B4)+14),""

but if (B) Date Last Serviced is blank I need it to add 14 days to (A) Date out.

Any help would be greatly appriciated

 

[Joe4]

Note that this:

DATE(YEAR(B4),MONTH(B4),DAY(B4)+14)

is all unnecessary, and can be simplified to just:

B4+14

I think this may be the formula you are looking for:

=IF(B4>0,B4+14,A4+14)

 

[somfin4u2c]

Works perfectly, Thank you!

 

[Joe4]

You are welcome!

Just a little extra "FYI" for you.
The reason you are able to just add the number to the date is because Excel actually stores dates as numbers, specifically, the number of days since 1/0/1900.
So dates are really just numbers with date formats in Excel.