Sounds good Roger - many thanks

"Roger Govier" wrote in message
...
Hi Terry

You could enter all your dates as the current year in column A.
Then in B1 enter
=DATE(1973,MONTH(A1),DAY(A1))
and copy down as far as required.
Copy all of the data in column B and Paste SpecialValues to "fix" the
data as 1973.
Repeat process for other year's required.

--
Regards

Roger Govier


"Terry Bennett" wrote in message
...
Sorry if this is a very basic query ...

I have to enter a large number of dates into a spreadsheet during the
period 1972 - 1976. Obviously, if you just enter a date into Excel using
the keystrokes 28/6, it assumes that you are referring to the current
year. As I will be entering the data in chronological order, how can I
avoid having to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is
there a way I can get Excel to treat all the dates as being in a
particular past year ... or can I enter them all as this year and then
change them in blocks somehow?

Any advice appreciated!