Date Listing

[chefmike]

Hi all,

Coming back to the pros for some help. What I have is a spreadsheet I have
have been using for the last couple of years and will hopefully in the
upcoming years. The first tab is called "Work Sheet" and it has raw data
that is updated daily. I have a hidden tab called "Data" where I have lists
and charts setup on that the worksheet retrieves data from.
One chart that is setup is a Date chart where cells "O4" to "P4" lists the
months of the year, the actual dates start in cell "P4". The chart is set up
where cell "O4" is January and "P4" is 1/1/2009. I have all 12 months and
all days of the month listed.
What I would like the chart to do is automaticly update when I change the
year on the worksheet.
The worksheet has a cell that lists the year, another cell that lists the
month, and yet another that list the number of days in that month.

Is it possible to update the chart on the "Data" sheet when I choose the
year on the "Work Sheet"?

Any help would be greatly appreciated.

Thanks mike

 

[Fred Smith]

If, say, A1, A2 and A3 have your year, month and day, to get a date in P4,
use:
=Date(a1,a2,a3)

Does this help?

Regards,
Fred.