Month to Date and Quarter to Date Average from Daily data

[asvanthi]

Dear Gents,

I am creating a database for daily production report. The structure will be date, To-day, Month To Date (MTD), Quarter To Date (QTD) and Year To Date (YTD). From the help provided by this forum I have managed to enter a formula which will calculate the MTD, QTD from daily data. I want to calculate MTD average and QTD average. Please help me in coining the formula for MTD average and QTD average. I don't want to change the formula every month and every quarter.

Please help me.

Attached is the worksheet.

[Ace_XL]

Please see attached. I changed the MTD and QTD formulas too

[alvin-chung]

Welcome to the forum!
You've interesting formula, is this what you're looking for Average MTD in F7?

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[alvin-chung]

Then try this for Average QTD in G7 (ps: calculation base on exact number of days between each quarter, leap year taken care as well)

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[asvanthi]

Dear Guru,

Many Thanks for your help. It works.