More Excel help please!

Soldato
Joined
26 Apr 2004
Posts
6,165
Location
Wrexham
I will try to explain as best i can!

I have a drop down box which a user can select a month, and in the column to the left of this there is a list of dates.

I would like this list of dates to show as follows:

01/03/2006
02/03/2006
03/03/2006

and so on to the end of the month. Is there any way i can get these cells to change automatically so when the user selects april, it changes the 03 to 04?
 
Back
Top Bottom