EXCEL - AUTO CHANGE YEAR?
Hello All!
Is there any way to format an auto year change when the years comes in a cell?
I know when it today's you set it for =TODAY() that will show 11/07/11.
How about if you just want the year , for instance 2011 then it will automatically change to 2012 then the following year will be 2013, 2014 or so on.
What I need just an auto when the years comes.
Please tell me if this is possible?
Please help! Thanks in advance!
More Questions From This User See All
Answers & Comments
Verified answer
you can just use Text.
=TEXT(NOW(),"YYYY")
=TEXT(TODAY(),"YYYY")
if you have =TODAY() in A1
you can enter "YEAR(A1)" and it will show 2011