Error trying to extract year from cell

[sharky12345]

I'm trying to extract the year only from a cell which is formatted as custom "dd/mm/yyyy hh:mm".

I'm using this but it's giving me an incorrect value;

Cell.Offset(0, 16).Value = Year(Cell)

'Cell' refers to the cell with the date and time, in this particular example it's '01/07/2019 10:00' and this should give me 2019 but I get 1905 - anyone?

I should add that I want to achieve the result by VBA and want to avoid a formula if possible.

 

[Joe4]

It works fine for me. Are you sure you are referencing the correct cell?
How is "cell" being defined?

 

[jasonb75]

Maybe 'Cell' is referring to the wrong cell? The code should work correctly, although (not essential but considered better practice) I would change it to Year(Cell.Value)
A return of 1905 would suggest a numeric value between 1828 and 2192 in the cell being used.

 

[sharky12345]

Guys thanks, just realised the error - the column was formatted as custom "yyyy" - changing it to General solved it.

Thanks to both though!