If Formula

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
 
M

Mike H

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
 
K

Kevin B

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

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