make a lookup table on a spare sheet with the numbers 0 to 20000 in
column A. In column B against the 0 and the 1 put "0-1 days"
against the numbers 2 to 7 put "2 - 7 days" and so on....
Against each of your dates, put a formula =date - May 1st. (you will
need to put the date May 1st in a spare cell, say Z1
so formula is =date-$Z$1. Look up this number in the lookup table.
--
robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php...o&userid=31996
View this thread:
http://www.excelforum.com/showthread...hreadid=551823