Inserting a column of date automatically

I

Igor

Hi,

I want to chart some data on a daily basis and I started a worksheet to do
this. The first column will show the date.

Rather than enter the date every day, I am hoping there is a way to
automatically have the date inserted into each cell in the first column,
each cell being one day.

Can anyone help me to do this? I was thinking it should be easily done but
I can't seem to figure it out. I hope I have clearly explained what I am
trying to do.

Thanks, John
 
S

Sandy Mann

Igor,

Assuming that the dates are in Column A starting from an actual date in A2,
enter:

=IF(B3="","",A2+1)

in A3. This will enter the date when data is entered in B2.

Copy the formula down using the fill handle

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
Top