Thread: How would I edit this formula to do what I want?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny boy Danny boy is offline
external usenet poster
  
Posts: 102
Default How would I edit this formula to do what I want?
I'd like to modify this formula so that the NO Flag appears if a date is
missing in BOTH X4 and Y4. The current formula generates the NO flag, if a
date is missing in either X4 or Y4. Any suggestions?

=IF(COUNT(X4,Y4)=2,IF(TODAY()Y4,"Yes",""),"No")
Reply With QuoteReply With Quote