Help calculating approvals for a specific item based on dates or no dates

Hi All,

Having one of those days where the brain isn't working as well as it should. Please help.

I need a formula that will look at A-I in Column H and if there is a Date in Column I for that matcing letter, that it comes back with "approved", if no date then it comes back with "not approved.


Kind Regards
TDF

This ...

=IF(AND(H3>="A",H3<="I",ISNUMBER(I3)),"Approved","Not Approved")

Hi TDF,

Quick and dirty solution is "=IF(NUMBERVALUE(I3)>36526,"Approved","Not Approved")" which will check for a date after 1st January 2000

Hope this helps.

Johann