View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Another If Formula Question

Hi,

It's customary to feedback and ask additional questions in the same thread.
Try this

=IF(COUNT(A1:B1)<2,"",IF(A1=B1,"Overdue",""))

Mike

"loomie" wrote:

Okay the if formula below that was given works great thanks!

With dates in a1 & B1 try this

=IF(A1=B1,"Overdue","")


However,if the date is blank it also returns false. How do I exclude blank
or make blank also overdue?