words and formula combined

[UPN]

I need to put in a cell the word "BY" and after that the anniversary date of person, but with current year plus 1 in it

Example: BY: 02/24/07 in cell G5

 

[Jon von der Heyden]

Hi,

You could use a custom format:

Format->Cells->Number->Custom : "BY:" dd/mm/yyyy

And then merely input / formulate the date in the cell.

Regards,
Jon

 

[big_mac]

Try format>cells>[number tab]>custom
put this as the custom format
"By: "m/d/yy