Thread: Date Formula results in a #VALUE! Error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default 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
Reply With QuoteReply With Quote