Hi
In Col A I have dates but Saturday and Sunday are excluded i.e only weekdays. I have date for several years.
In Col B I have prices.
In col C I wish to calculate the 30 day moving price average WITH weekend included in the 30 day count.
Any suggestions please?
Best Regards
Mark
In Col A I have dates but Saturday and Sunday are excluded i.e only weekdays. I have date for several years.
In Col B I have prices.
In col C I wish to calculate the 30 day moving price average WITH weekend included in the 30 day count.
Any suggestions please?
Best Regards
Mark