Yep...at home now...I did change the dates to accomedate the condition...it
didn't work. I need this spread sheet this week.....yikes! my original
formula worked on the past dated (expired)items...but not when I changed the
dates to see if it worked...I changed some to january some to later this
month...and nothing happened.

Thanks for your help driller.
--
Jules


"driller" wrote:

u still there ?

"driller" wrote:

Jules...your dates are not within the 60 day range start from today 15
nov.06...the nearmost date is 09 Feb. 2007....
Try changing one date like Nov.30 or Dec. 30. 2006...

"Jules" wrote:

Driller...here are the exp dates...in Column E and this workbook will grow...
EXP DATE
10/01/10
08/09/09
06/12/09
06/12/09
06/12/09
06/12/09
08/18/09
08/18/09
08/18/09
08/18/09
06/29/09
06/29/09
06/16/09
06/16/09
06/16/09
05/18/11
05/18/11
05/18/11
05/17/11
05/17/11
05/17/11
07/14/09
07/14/09
02/27/09
02/27/09
01/22/09
01/22/09
01/22/09
01/22/09
01/22/09
01/22/09
12/20/08
12/20/08
12/20/08
12/20/08
09/12/09
09/12/09
09/12/09
11/03/08
11/03/08
11/03/08
04/01/08
11/03/08
04/20/09
04/20/09
09/12/09
05/10/09
05/10/09
05/10/09
09/27/08
09/27/08
01/13/06
07/29/07
07/29/07
01/01/08
08/26/08
07/18/08
07/18/08
07/29/07
07/31/09
11/01/06
07/29/08
07/29/08
07/29/08
07/19/08
09/08/08
08/02/08
08/02/08
08/02/08
08/02/08
07/19/08
10/09/08
08/26/08
09/08/08
04/26/07
08/02/08
09/08/08
01/31/08
10/10/08
10/09/08
10/10/08
06/09/07
12/10/07
06/09/07
06/15/07

01/06/08
09/27/07
04/26/07
08/02/08
05/06/07
09/08/08
10/10/07
10/13/07
02/09/07
12/12/07
12/12/07
04/26/07
05/28/08
05/06/08
06/05/08
03/15/08
11/03/08
10/12/07
06/15/08
10/10/08
10/13/07
03/07/08
03/07/08
10/16/07
10/16/07
06/03/08
06/03/08
09/15/06
10/12/07
10/10/07
05/06/08
06/25/08
11/02/07
11/02/07
10/20/07
10/20/07
01/11/08
12/01/07
03/30/08
03/30/08
06/27/08
11/28/07
11/28/07
11/28/07
07/28/10
08/11/07
07/18/08
08/01/08
05/08/08
05/08/08
02/12/09
02/07/09
02/07/09
04/11/08
02/07/09
02/08/09
03/30/09
03/30/09
04/18/08
07/18/08
08/03/08
08/03/08
03/27/07
06/01/09
11/01/08
12/31/07
03/01/09
03/01/09
07/29/08
04/29/07
11/12/06
07/30/08
07/30/08
06/01/09
04/30/09
06/01/09
11/30/08
11/30/08
11/30/08
11/30/08
08/31/08
08/31/08
12/31/07
08/31/08
08/31/08
07/31/08
07/31/08
11/30/07
11/30/07
05/01/08
02/28/08
05/01/07
06/15/07
12/14/07
06/29/07
12/05/07
12/21/07
09/13/06
09/28/06
09/12/07
04/05/09
02/26/09
03/20/09
04/30/13
07/31/07
09/06/07
07/01/08
07/31/08