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

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

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

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

Maybe it's just:

=if(h6date(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 wrote:

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

--

Dave Peterson

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


"Dave Peterson" wrote:

Maybe it's just:

=if(h6date(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 wrote:

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

--

Dave Peterson