Year Function

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

I have dates in one column. The year of the date shows in another column.
How do I get the year to show as two digit (08 etc).

Thanks
 
Lets say you have a date in A1

1/1/2008

put this in b1
=A1
format B1 as yy and it wil display as 08

Mike
 
you can format the column. Put the date in colum A, then make column B equal
to Column A (in cell b1 type =a1 and drag that down). Then select column B
and go to Format / Cells and choose Custom then type in "YY" in the Type box.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Power Pivot Variance Column 0
Date Format 1
Adding 10 years to a date 2
Start and End date 2
Remove date format? 3
Pivot Table Dates 1
EXPIRED or DATE 3
Combo Bar-Line Graph with single list of data 1

Back
Top