Thread: dates max & min
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelFan excelFan is offline
external usenet poster
 
Posts: 53
Default dates max & min

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