Excel formulas

M

Mike

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
 
P

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
 
Top