I need to write a macro which looks at a column of dates, takes the Minimum
date (earliest) and the maximum date(latest) and figure out how many weeks
have passed between the two. I recorded a macro, but that limits me by
forcing me to select the exact cells. It is fine on one set of data but I
need to use this over and over with a variable number of data rows. Any
suggestions?