Hello,

I am attempting to automatically fill a row with dates.

In Cell A5, I enter the first day of the month eg 1 April 2010.

I then want the adjacent columns to automatically fill with the subsequent
dates eg cell B5 is 2 April 2010, cell C5 is 3 April 2010 etc,

It must only fill upto and including the last day of the month and not roll
into May. These cells then allow my Vlookup function and graph to operate
solely for that particular month.

Obviously just adding +1 to the previous cell will do this, but then I may
end up with dates in the next month which is what I need to avoid.

Preferably the function would only work when the date in A5 is changed so I
would like to avoid using a button.

Regards
Ant