ExcelBanter - If Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Formula (https://www.excelbanter.com/excel-discussion-misc-queries/216323-if-formula.html)

loomie

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

Mike H

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

Kevin B

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

All times are GMT +1. The time now is 06:12 AM.