If Formula

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

loomie

Can anyone help me out with a formula that would do the following in excell:


If date X = to or less than date X, result shows overdue
 
Hi,

With dates in a1 & B1 try this

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

or to compare a date to todays date

=IF(TODAY()>=B1,"Overdue","")

Mike
 
Change the cell addresses of A1 and B1 to your date value cells:

=IF(A1<=B1,"Overdue","")
 
You must log in or register to reply here.

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
Conditional formatting, coloring the whole row 2
IF command with In Progress, Overdue, and Closed results? 3
macro for displaying conditional formatting 1
Another If Formula Question 2
Not sure what I need other than help 4
Excel Excel due and overdue date colours 2
IF 1

Back
Top