Current Year to display in text

[Gadgetman]

Is there a way to get the current year to display in a title if there is
other text with it?

For example:
I have a sheet with the following text in it: 2011 Benefit Time

I'm looking for a way have just the year update itself at the change of
the new year so when someone opens a blank form in 2012, it will read
2012 Benefit Time

Again, the title is all in once cell with it centered. I would rather
not place the date in the cell by itself. Is there a way to insert just
a date prior to text inside a cell? Or Is there an insert date option
like in MS word?

 

[Claus Busch]

Hi Gadgetman,

Am Thu, 23 Jun 2011 14:49:25 -0400 schrieb Gadgetman:

I'm looking for a way have just the year update itself at the change of
the new year so when someone opens a blank form in 2012, it will read
2012 Benefit Time

try this:
=YEAR(TODAY())&" Benefit Time"


Regards
Claus Busch

 

[Gadgetman]

WORKED! Thank you very much.

Hi Gadgetman,

Am Thu, 23 Jun 2011 14:49:25 -0400 schrieb Gadgetman:


try this:
=YEAR(TODAY())&" Benefit Time"


Regards
Claus Busch

 

[Rick Rothstein]

WORKED! Thank you very much.

I think it might be a mistake to do this with a formula. While the year is
correct right now, next year if you look at the document, the year will be
wrong (it will say it is 2012 when it is not), but there will be no
indication of that. Really, how difficult is it to hard-code the four digit
year into your text constant?

Rick Rothstein (MVP - Excel)

 

[GS]

Rick Rothstein used his keyboard to write :

I think it might be a mistake to do this with a formula. While the year is
correct right now, next year if you look at the document, the year will be
wrong (it will say it is 2012 when it is not), but there will be no
indication of that. Really, how difficult is it to hard-code the four digit
year into your text constant?

Rick Rothstein (MVP - Excel)

Exactly! I enter the current year for the workbook into a defined name
(global scope) cell ("ThisYear") as a constant and ref that in all
cellssheets that use it.

Example:
In the cell using the year: =ThisYear&" Benefit Time"

 

[GS]

"cellssheets"
should read
"cells/sheets"