Date plus 30 days but tidy

[tony_d]

Is there a formula to put a date plus a set number of say 30 days as a reminder.

So if I enter a date in cell A1 and a number in B1 I want cell c1 to return A1+30

But I want to tidy it up so if there isn't a date in A1 nothing shows in C1

Something possibly based on if(b1>.01 then "A1 +30days","") which I know doesn't work

 

[JD_GFI]

Try this:

=IF(A1<>"",(A1+B1),"")

Make sure column C is formatted as date.

 

[T. Valko]

Is there a formula to put a date plus a set number of say 30 days as a reminder.

So if I enter a date in cell A1 and a number in B1 I want cell c1 to return A1+30

But I want to tidy it up so if there isn't a date in A1 nothing shows in C1

Something possibly based on if(b1>.01 then "A1 +30days","") which I know doesn't work

You pretty much had your own solution!

Try this...

IF(A1="","",SUM(A1,B1))

Format as Date