Thread: Date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Date?
Because either A3 is blank or B3 is not blank.

Regards
Fred

"Richard" wrote in message
...
Why will this formula not return the correct date?
=IF(A3="","",IF(B3="",NOW(),B3))

Reply With QuoteReply With Quote