I need the formula to acknowledge the expiration date. Formula states "if
the expired column is greater than the expiration date than it is "ok" - if
it is less than it is "xx".

Dave I tried your suggestion and it worked with the expiration date of
1/1/2009, but not for the expiration date of 10/15/2005.

Thanks everyone for helping me to resolve this.
--
Olives


"leerem" wrote:

according to your formula you have contradicted yourself:

H5 is greater than 24th Sept and H5 is less than 24th Sept ????
Select the date you require in say another cell eg H6
Try this =if(and(H5H6,H5<H6),"OK","XX")

"olives" wrote:

I entered the following formula in my spreadsheet - in the Expired column,
and it is not working. Is this not the right formula to use with dates.


=IF(AND(H59/24/2008,H5<9/24/2008),"ok","xx")



Expired Insured Type of Insurance Expiration Date

xx Company X General Liability 1/1/2009
xx Company X Workers Compensation 10/15/2005
--
Olives