Inserting a column of date automatically

[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

 

[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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Igor]

Sandy,

Thank you very much. All is well now.

John