Need Help Adding Auto Changing Year.

dmontez

New Member
Joined
Nov 17, 2008
Messages
25
I have a over 150 reports that I create weekly and would like the year to change automatically in the cell where I have my copyright info. Don't want to chenge them all by hand each year. :)

Should read:

Copyright © 2009 TMOReport.com



Thanks!
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

="Copyright © " & TEXT(TODAY(),"yyyy")&" TMOReport.com"
 

Watch MrExcel Video

Forum statistics

Threads
1,108,482
Messages
5,523,207
Members
409,504
Latest member
Joshcurrie

This Week's Hot Topics

Top