You could use an the offset command. This command allows you to offset
(shift) the references in your formula. You will need a cell to tell Offset
how far over to go

Another idea is that if the numbers are blank until you have data, I think
excel will ignore them for average purposes

"Ellen" wrote:

Would like to create a formula that will adjust dependent on the current
month. We are trying to get an average through the current month and do not
want to have to change the formula each month to include the latest month.

Thanks. - Ellen