This is an array formula that must be entered using ctrl+shift+enter vs just
enter. ans=1190
=MAX(IF(B6:B14="azm",A6:A14))-MIN(IF(B6:B14="azm",A6:A14))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"excelFan" wrote in message
...
hi all, please help

A B
--------- ----------
date item
--------- ----------
02/14/04 azm
07/22/05 naf
11/21/05 naf
03/26/06 naf
04/18/07 naf
04/20/07 azm
05/19/07 azm
06/08/07 ktm
08/22/07 ktm

i like to find the number of days between max and min dates for a given
item
in column B