I have a huge spreadsheet that I am typing dates into from past years. Is
there an easy way to tell certain cells that they are 2003 or 2004 so when
for example I tell the cell 2/11, it won't pop up 2/11/08 automatically it
will pop up 2/11/03 instead? I have to change year dates about 3-5 times
during this and there are probably 2000 entries I need to make before the day
is through and an easy formula would sure help, can anyone suggestion
something to get me started?