Excel formulas

[Guest]

Can I set it up to where if there is a date in cell b1 then c1 is b1+28 (for
28 days)but if there is no date in b1 then c1 is blank? I can do the first
part but I don't know if the second part can be done. Thanks

 

[Pete_UK]

Try this in C1:

=IF(B1="","",B1+28)

Format C1 as date. Actually, this doesn't test specifically for dates,
just for B1 being blank.

Hope this helps.

Pete