Date Formula results in a #VALUE! Error
 

=IF(N562="Yes",P562+20,P562+45),IF(P562+45=45,S56 2+45) I have this formula in cell Q562 and I get a #VALUE Error!. The formula is referencing dates plus either 20 or 45 days. In the second part of the formula I'm trying to say if the date in P562 is equal to or greater than 45 days then take the date in S562 add 45 days to it and this is the new deadline date. I cannot find out what is wrong with this formula. Help??

Date Formula results in a #VALUE! Error
 

Hi,

Am Tue, 26 Dec 2017 09:33:06 -0800 (PST) schrieb :

=IF(N562="Yes",P562+20,P562+45),IF(P562+45=45,S56 2+45) I have this formula in cell Q562 and I get a #VALUE Error!. The formula is referencing dates plus either 20 or 45 days. In the second part of the formula I'm trying to say if the date in P562 is equal to or greater than 45 days then take the date in S562 add 45 days to it and this is the new deadline date. I cannot find out what is wrong with this formula. Help??

try:
=IF(N562="Yes",P562+20,IF(P562+45=45,S562+45,P562 +45))

If that formula doesn't give the expected result post some examples and
explain which results are wanted.


Regards
Claus B.
--
Windows10
Office 2016

Date Formula results in a #VALUE! Error
 

Yes, that is the correct answer. Thanks very much for your help. It is greatly appreciated.



On Tuesday, December 26, 2017 at 12:33:10 PM UTC-5, wrote:
=IF(N562="Yes",P562+20,P562+45),IF(P562+45=45,S56 2+45) I have this formula in cell Q562 and I get a #VALUE Error!. The formula is referencing dates plus either 20 or 45 days. In the second part of the formula I'm trying to say if the date in P562 is equal to or greater than 45 days then take the date in S562 add 45 days to it and this is the new deadline date. I cannot find out what is wrong with this formula. Help??