Another If Formula Question

  • Thread starter Thread starter loomie
  • Start date Start date
L

loomie

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If cell is blank automatically enter today's date in the same cell 21
Help with a date formula 1
Conditional Format - Due Dates - 2 questions (2nd posting) 2
How do I highlight a cell when a date is overdue? 2
IF Statement - Correct Function? 6
Formula in B1 8
Need Formula - If blank cells 3
IF Then 3

Back
Top