I'd use this syntax:

=IF(AND(H5date(2008,9,24),H5<date(2008,9,24)),"ok ","xx")

But there aren't going to be any dates that are bigger than 9/24/2008 and
smaller than 9/24/2008 at the same time. (Maybe a typo???)



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

--

Dave Peterson