Thread: Excel formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Excel formulas

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

Mike wrote:
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