I am using Excel 2003 and often need to enter dates in the first column. The dates are rarely sequential, but often are in the same year. I really hate having to type in day, month, year in each row.
Typing just day/month will automatically default to current year. What I would really like is for a new entry to default to a specific year of my choosing (I am entering dates for years prior to current year) so that all I need to do is enter day and month.
Using a date format that only shows day and month is not a good solution because the printed worksheet requires dd/mm/yyyy format.
I know from playing with Access some 25 or so years ago that this would not be difficult; but finding how to do it in Excel has been a real pain.
The REAL killer is I could swear that I saw a tip book about 5 or 6 years ago where the author mentioned how to do this.
To recap:
I would like to enter day/month in column A (I typically utilize lists) and when I enter the next row of data, have the YEAR value in the cell default to either the year in the cell above (ideally) or from a value obtained from another cell. Heck. even default to some predeterimed year value as Excel does now with current year.
thanks for any assistance in advance