ExcelBanter - =Right Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - =Right Function (https://www.excelbanter.com/excel-programming/301174-%3Dright-function.html)

Sanj

=Right Function

Hi All

Can any one tell me what this means:

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

In a cell where the contents are a date lets say
11/06/2004, I'd like to get the year from the date.

Can you help?

Frank Kabel

=Right Function

Hi
see your other post

-----Original Message-----
Hi All

Can any one tell me what this means:

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

In a cell where the contents are a date lets say
11/06/2004, I'd like to get the year from the date.

Can you help?
.

All times are GMT +1. The time now is 10:03 PM.