I have a worksheet which is like this below whic provides a headcount for a
particular day. The sheet stretches over 80 days....

A B C D E F
Suffix Resource 1/1/01 2/1/01 3/1/01 4/1/01
CS01 Welder 4 4 5 3
CS02 Fitter 7 8 6 7
CS03 Electrician 3 3 3 3

On another sheet I would like to have the today fromula up to munis 6 so
that I can have summarised data for one week. And this will also pull the
information from within the date column and update itself accordingly in line
with todays date and so on for the previous dates.

Is is possible to have a formula that will be constantly update and transfer
my required information on a daily basis?

Any help will be greatly appreciated.