leave blank if no value - if or sumif?

[mapyrant]

I'd like to populate a "due date". Which is 14 days from a value in the previous column. But if there is no date in the previous column, I'd like the cell to remain blank. I'm struggling on this one. Thank you,

 

[Debaser]

=IF(A1="","",A1+14)

where A1 is the date cell.

 

[mapyrant]

This is awesome, thank you!

Would it be possible to add multiple arguments?

i.e. =IF(A1="","",A1+14) ... BUT ILO +14, could i say if column D = Blue, do +14, if column D = green, +28, if column D = Red, +21, etc?

 

[Debaser]

If column D contains the word "Blue" etc, then yes. If column D is actually coloured blue, then no (at least not without code).

 

[mapyrant]

That makes sense- I used Excels new help function to plug these in and it worked!! Thanks so much for your help!

 

[pecoflyer]

To avoid a long formula, you can also build a small table of values say B1:B3 containing the words blue, green, yellow (say) and your formula then boils down to something like =IF(A1="","",match(D1,B1:B3,0)*7)