Get just the year from a date string

[jshaw82]

Hi All,

I need to get the year for a formula

The formula will be:

Please Login or Register  to view this content.

The A1 and B1 is from a date e.g 01/01/2013, 01/01/2014 - these cells have to stay in date format as they are being used for something else and I also want the code to automate

The above code gives me 41275/41640 but I want it to be 2013/2014

Can anyone help?

John

[Jonmo1]

Try

=YEAR(A1)&"/"&YEAR(B1)