Using MS Excel to track the amount of oil we use, I'd like to create a more
standardized way of looking at monthly usage. Deliveries of oil are somewhat
random (Nov 21, Jan 3, Feb 27, etc.). I want to be able to create an average
by month (for comparison to prior years). I can do this manually by looking
at the number of days in the current month and in the prior month between oil
deliveries, and then applying the daily average usage to each month, but this
is highly manual and tedious. Is there a way to automate that allocation
process to create more reliable monthly data?

Thanks for your thoughts.

Example: If we get 150 gallons on Mar 8, and the prior delivery was Feb 22,
then average daily usage was 10.7 gallons. I can take 10.7, multiply by
eight days in March and assign the result (85.7 gallons) to March and the
rest of the delivery to February (64.3 gallons). While not perfect,
especially if a delivery is close to the end or the beginning of a month, it
does allow a more precise comparison to prior years.