What code would you use to enter only the current year in a selected cell.
Ex. "2012"
What code would you use to enter only the current year in a selected cell.
Ex. "2012"
Please Login or Register to view this content.
And if you get a date in a1 e.g. 2012-08-07
You can get the year (in cel B1) with the formula =year(a1).
It returns the value 2012
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks