repeat year in dates

how do I get excel to fill in the desired year (other than current).
thnks,
Russ

I am indexing marriage records for our county archives.
I would like to just enter the marriage date and have excel
fill in the year date for whatever year I'm indexing.

It works this way for the current year but not other
years. Thought about changing the computer date to the desired
date and then changing it back after completing my days indexing
Thanks,
Russ

Other than the work-around you suggested, I think this would require VB code.

You need
1. a way to tell Excel which year you want to use, and
2.a way to tell Excel when and how to use it.

The first could be as simple as putting the year you are indexing in a cell.

The second would require a Worksheet_Change Event procedure. That procedure would look for a date being entered and change the year from the default (this year) to another year (the one you told Excel about in step 1).

If I think of another way, I'll let you know. But, that is what comes to mind immediately.

Thanks, I'll see if I can work it out.
In the meantime keep thinking
Russ

Thanks oldchippy old chappy
Russ