Convert Daily Production Data To Monthly or Yearly Data

xiaobaiw

If you have big daily production data, sometime it can take your time to convert them to monthly or yearly production using Excel Average function. Depending how fluent use your Excel spreadsheet.

There is an easier way to do this is using the capability of Ms. Excel to do array calculations. This calculation is marked by curly brackets “{}”. You can find an example converting daily data to monthly or yearly in this tool. Please note that you can use this idea to any daily data to convert them to monthly or yearly.

Hint: When editing an array formula press Shift & Ctrl buttons (don’t release them yet) then hit Enter to apply.