Microsoft Excel - Year
Asked By Dan on 01-Aug-11 11:13 AM
Does any one know how to just display the year in a cell? If I put in =now() I get the Month/Day/Year. I just want the current year.
Thanks
Riley K replied to Dan on 01-Aug-11 11:33 AM
If cell A1 has your full date 11/12/1987
Then in cell C1 enter =YEAR(A1)
regards
Riley K replied to Dan on 01-Aug-11 11:35 AM
Use the Year function to display only Year
|
|
| A |
| Date |
| 7/5/2008 |
| 7/5/10 |
| Formula |
Description (Result) |
| =YEAR(A2) |
Year of the first date (2008) |
| =YEAR(A3) |
Year of the second date (2010) |
|
Pichart Y. replied to Dan on 01-Aug-11 11:43 AM
Hi Dan,
use format cells>Custom then in the field type input the yyyy
**then you get only 2011
pichart Y.
SRE replied to Dan on 01-Aug-11 12:03 PM
Hi go Through This Screen Shot you will find the solution
Right Click on the Cell and select Format Cells
SRE replied to Dan on 01-Aug-11 12:08 PM
HI There is another Solution for this.
Just Enter the Following Formula in the Cell then it will display Year only
=YEAR(NOW())
Reena Jain replied to Dan on 01-Aug-11 12:43 PM
Hi,
You can do it in two way
=NOW()
Then you have to go to format cells, change the format to custom and type in yyyy
or
Try
=MONTH(TODAY())
=Year(TODAY())
Hope this will help you
pete rainbow replied to Dan on 01-Aug-11 02:03 PM
you can either format the cells using the usual way, this being the best performance method
or extract the year using the function YEAR, which i would avoid if it's just a GUI thing, but if you really need the data then use
Dan replied to pete rainbow on 01-Aug-11 02:52 PM
Wow, thanks for the response, all answers have been very helpful. Thank you.
Jitendra Faye replied to Dan on 02-Aug-11 12:47 AM
Yes, now() give give you complete date.
if you want to use only year then use year() .
like this-
= YEAR(your Cell value)