Year Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graham - 26 Apr 2008 12:09 GMT

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

Reply to this Message

Mike H - 26 Apr 2008 12:18 GMT

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

> 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

Reply to this Message

muddan madhu - 26 Apr 2008 13:41 GMT

I think date in A1, year in B1 so C1 put =right(B1,2)

> Lets say you have a date in A1
>
[quoted text clipped - 12 lines]
>
> - Show quoted text -

Reply to this Message

Don - 26 Apr 2008 17:02 GMT

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.

> 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

Reply to this Message