Days360 Formula in VBA error
No macro needed
With the dates in Column B:
=(MAX(B:B)-MIN(B:B))/7
Decide how you'd like to round
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Brian A" wrote in message ...
|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?
|