Get Year
Use
=YEAR()
as in
=YEAR(A1)
.
Be careful with formatting. To get the current year, you can use
=NOW()
or
=TODAY()
and format as
yy
or
yyyy
to get
04
or
2004
. (You can use the TEXT function as in
=TEXT(TODAY(),"yyyy")
also)
© Copyright
andrewsexceltips.net
All Rights Reserved.