#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.
|