Thanks for the tip!!
What if I enter the value 2004 in a cell and I then want other cells to show
"December 2003" and/or "11/30/04" and if I change the value of the first cell
to 2005, 2006, 2007, etc. I want to show "December 2004" etc. respectively.



"flotowntiger" wrote:

Can you have a cell return a value based on another cell's input. Ex: If I
enter the year 2004 in a specific cell then I want another cell to display
the date 12/01/03 or some other date or value that I would pre-determine.