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