date format and the RIGHT function

[Rich Hayes]

In sheet 1 cell A1 i have a date that is generated from another sheet, the
date in this cell reads 'Jun-2005' (The cell is in mmm/yyyy format)

In cell B1 I have used the formula;

=DATE(YEAR(A1),MONTH(A1)+1,1)

This therefore returns the date 'Jul-2005' in cell B1.

I have continued this formula across row 1 for several columns.

In sheet 2 I have linked cells to those in sheet 1 as below;

cell A1 = 'Sheet1!A1 - this returns 'Jun-2005'
cell B1 = 'Sheet1!B1 - this returns 'Jul-2005'

Now in row 2 on sheet 2, i enter the following formulae and get the
following results.

cell A2 = right(A1,2) - this returns '05'
cell B2 = right(B1,2) - this returns '34'
cell C2 = right(C1,2) - this returns '65'

Is there any reason i get 34 returned for Jul 05 and 65 returned for Aug 05?
I need it to return '05'.

Any help you can be is very much appreciated,

Regards

Rich

 

[SteveG]

Rich,

Your formula is returning the last two digits of the Excel serial
number for the date. July = 38534, Aug = 38565, Sept = 38596. Use
this instead.

=RIGHT(YEAR(C1),2)

HTH,

Cheers,

Steve