#value! for calculating date

[Guest]

I have a quote template with calculates a "quote valid until" date based on
adding 30 days to the date of the quote.

The issue I have is that if the quote date isn't entered in, I get a #VALUE!
in that cell because it has nothing to calculate the formula on.

Do you have any work arounds for this?

I can't have the quote date automatically filled in because it changes
everytime you reopen the quote.

 

[Dave Peterson]

=if(a1="","",a1+30)
or
=if(a1="","Please enter a date in A1",a1+30)

 

[Pete_UK]

You could try something like:

=IF(A1="","","Quote valid until "&TEXT(A1+30,"dd/mm/yyyy"))

where A1 contains your quote date - adjust as required.

Hope this helps.

Pete