dates

[jerimi]

Hello all,

i would like to display the last number of the year in a
cell. i.e. for 2004, I would like the cell to read 4.
Can this be done?

thanks

 

[Norman Harker]

Hi Jerimi!

With a date in A1:

=A1
Format y or yy

Unfortunately that displays 04

Or:

=MOD(YEAR(A1),10)

 

[Frank Kabel]

Hi
if you have 2004 as value in cell A1 try
=RIGHT(A1,1)