Hi there I am wondering if anyone out there can help me out with a data
conversion macro. I need a macro with a UserForm interface that uses RedEdit
dropdown boxes to allow you to select a range of streaming daily data (based
on 5 day working week) and have excel convert it into a weekly data stream
by averaging the values for each single weekday into one value for that week.

???
Any thoughts.
P.S is there some sites in which have these types of date conversion /
Manipulation?

Thanks,
Dan.