| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula
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 "loomie" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula
Change the cell addresses of A1 and B1 to your date value cells:
=IF(A1<=B1,"Overdue","") -- Kevin Backmann "loomie" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
