One way:

For December 2003:

A1: 2004
B1: =DATE(A1,0,1)

Format B1 with Format/Date/Number mmmm yyyy

For 11/30/04:

C1: =DATE(A1,0,0)




In article ,
flotowntiger wrote:

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.