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

On Apr 27, 12:00 am, NANGO wrote:
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.