If you did not have not delivered you could use a lookup table, but the
following should suffice

=IF(B1<91,"0-90 days",IF(B1<181,"91-180 days",IF(B1<366,"181-365
days","Not Delivered")))

but a blank will return 0-90 days and anything above 365 eg 400 will
return nor delivered

If you wish to exclude blank

=IF(AND(B1<91,ISNUMBER(B1)),"0-90
days",IF(AND(B1<181,ISNUMBER(B1)),"91-180
days",IF(AND(B1<366,ISNUMBER(B1)),"181-365 days","Not Delivered")))

the above can probably be shorter but it works!

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=514321