Formula

[olives]

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(H5>9/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

 

[Dave Peterson]

I'd use this syntax:

=IF(AND(H5>date(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???)

 

[leerem]

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(H5>H6,H5<H6),"OK","XX")

 

[olives]

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.

 

[Dave Peterson]

Maybe it's just:

=if(h6>date(2005,10,15),"ok","xx")

I'm not sure why the formula would work for one date, but not another.

You may want to share the formulas you used.

 

[olives]

Dave you're the greatest! This formula worked. Thanks a million for all
your help