Only perform an if statement if the contains a date and ignore other data

[Engineerlee]

Hi,

I have a cell A1
this contains a formula to pull a date from another worksheet using an Index and Match Formula

In Cell A2 I want to perform a check to see if that date is greater than or less than today.
The problem I have is that my formula in Cell A2 is seeing the formula in A1 and always returns a value even if no date is displayed.

This is my formula in A2
<today(),"overdue","not due")<today(),"overdue","not="" due")
<today(),"overdue","not due")
<today(),"overdue","not due")="" "
IF(K25<TODAY(),"OVERDUE","NOT DUE")<today(),"overdue","not due")
<today(),"overdue","not due")


Any advice.</today(),"overdue","not></today(),"overdue","not></today(),"overdue","not></today(),"overdue","not></today(),"overdue","not>

 

[Eric W]

FYI, sometimes a < symbol can be interpreted as an HTML tag, which is why your formula got cut off. The easiest way to avoid that is to put a space after each one, like this:

=IF(K25< TODAY(),"OVERDUE","NOT DUE")

You can probably change your formula to something like this:

=IF(K25="","",IF(K25< TODAY(),"OVERDUE","NOT DUE"))

 

[Engineerlee]

Not sure why but the formula I have placed in the thread isnt fully visible
Below is what should be displayed

=IF(A2<TODAY(),"OVERDUE","NOT DUE")

 

[Engineerlee]

Hi Eric,

Thanks for your prompt response,
Unfortunately this doesn't work
I still Get Overdue returned

 

[Fluff]

The formula in A2 should be
=IF(A1< TODAY(),"overdue","not due")
When posting a formula that contains either < or > make sure there is a space either side of them. Otherwise the board's software treats them HTML code.

 

[Eric W]

What formula do you have in A1, or is it A2? I'm a bit unclear as to which cell you want to check.

 

[Engineerlee]

thanks Fluff

 

[Engineerlee]

Hi Eric
Apologies.

A1 contains a formula to Pull a date from another sheet
I want to check A1 to see if the date is greater than or less than Today, using a formula (below) in A2
However I always return "Overdue" in A2

=IF(A1 < TODAY(),"OVERDUE","NOT DUE"))

Hope that helps

 

[Eric W]

Have you tried the formula I suggested in post 2?

=IF(A1="","",IF(A1 < TODAY(),"OVERDUE","NOT DUE"))

If it does not work, what is the formula in A1? You said there's an INDEX formula there to get the date from another sheet. If the date is unobtainable for some reason, we need to see what that formula returns instead of the date, and check for that in the A2 formula.

 

[Engineerlee]

Hi Eric,

Here is the Index and Match from A1

=IFERROR(INDEX('1.1 Centre '!$Q:$Q,MATCH(Schedule!F25,'1.1 Centre '!$D:$D,0),1),"")

Not sure if this also adds to the problem, but to prevent a default date of 00/01/1900 being returned if the index match returns nothing I have a custom Format for A1 cell of dd/mm/yyyy;;

cheers