Hi,

I am trying to create a formula that will dynamically calculate a 6 period
average based on a date. I am using Excel 2003 SP2.

Specifically:
Row 1 contains a series of dates (Week Commencing)
Row 2 contains the data I would like to average (Man Days expended during
the week)

I would like to create a calculation that uses the current date, i.e.
references a cell that contains =TODAY(), and calculates the average number
of man days expended per week for the previous six weeks so that when the
current date changes, a new six-week average is generated.

I would be happy to mail the spreadsheet if required.

I very much look forward to hearing from someone.

Thanks,

Paul