Hi
the use the formula
=IF(A1<"",DATE(A1-1,12,31),"")
and format this cell with the date format you want. e.g.
MMMM YYYY
or
MM/DD/YYYY
--
Regards
Frank Kabel
Frankfurt, Germany
"flotowntiger" schrieb im
Newsbeitrag ...
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.
|