= Right((Cells(2, 2)), 4)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All

Can explain the following function

= Right((Cells(2, 2)), 4)

Basicall I need the RIGHT funtion to provide me with yyyy
of the following date 11/06/2004

can you help?
 
Hi,

If the cell is formatted as a true date, try

=YEAR(A1)

otherwise, try

=TEXT(A1,"yyyy")

or

=RIGHT(A1,4)

Hope this helps!
 
Back
Top