need to align diff date ranges and frequencies

[sarar]

I need to align multiple time series that have different date ranges and frequencies so I can analyze and compare. I am new to coding in excel and was trying to code a macro that would insert rows and line them up.

I've attached a workbook with a small subset. I think it would be best to get them all into a weekly series..most are 28days or 7day with one that is daily.

I thought about getting them all in daily then going to weekly for analysis but might just be easier to convert all to weekly. One problem is that some of the weekly time series are weekly on a Mon, tues or Friday...they are not consistent.

I've searched this site but nothing really covered this and would appreciate any help at all!! thanks in advance!!

[rylo]

Hi

See if this helps.

Please Login or Register  to view this content.

It only works on the monthly data. From there, you could use the weeknum function to determine the week for comparison purposes.

HTH

rylo

[sarar]

thanks! I'll check this out