#value! for calculating date
 

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.

#value! for calculating date
 

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



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.

--

Dave Peterson

#value! for calculating date
 

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.