date format and the RIGHT function
 

I have in sheet 1, cell A1 a date which says Jun-2005 (the cell format is
mmm-yy and this date is linked to another diff sheet)

Because the date in cell A1 will change I have driven cell B1 from this cell
with the formula:

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

This therefore returns the date Jul-2005

and cell C1 returns Aug-2005 etc etc.

In sheet 2,

Cell A1 = 'Sheet 1'!A1 which returns Jun-2005
Cell B1 = 'Sheet 1'!B1 which returns Jul-2005

Now the issue I have is the next step.

In cell A2, i'm trying to do a formula that will return just '05' therefore
I use the formula:

cell A2 =RIGHT(A1,2) which returns '05'

In cell B2 though, i use the same formula;

cell B2 =RIGHT(B1,2) but it returns '34' regardless of cell format.

Is there a way to make sure this returns '05' as well?

Thanks for your help

Regards

Rich

date format and the RIGHT function
 

One way:

A2: =A1

Format A2 using

Format/Cells/Number/Custom yy

And copy across.

Or, if you'd rather have A2 as a text value:

A2: =TEXT(A1,"yy")


In article ,
"Rich Hayes" wrote:

I have in sheet 1, cell A1 a date which says Jun-2005 (the cell format is
mmm-yy and this date is linked to another diff sheet)

Because the date in cell A1 will change I have driven cell B1 from this cell
with the formula:

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

This therefore returns the date Jul-2005

and cell C1 returns Aug-2005 etc etc.

In sheet 2,

Cell A1 = 'Sheet 1'!A1 which returns Jun-2005
Cell B1 = 'Sheet 1'!B1 which returns Jul-2005

Now the issue I have is the next step.

In cell A2, i'm trying to do a formula that will return just '05' therefore
I use the formula:

cell A2 =RIGHT(A1,2) which returns '05'

In cell B2 though, i use the same formula;

cell B2 =RIGHT(B1,2) but it returns '34' regardless of cell format.

Is there a way to make sure this returns '05' as well?

Thanks for your help

Regards

Rich

date format and the RIGHT function
 

Thanks for your help. Relaly appreciate it!



"JE McGimpsey" wrote:

One way:

A2: =A1

Format A2 using

Format/Cells/Number/Custom yy

And copy across.

Or, if you'd rather have A2 as a text value:

A2: =TEXT(A1,"yy")


In article ,
"Rich Hayes" wrote:

I have in sheet 1, cell A1 a date which says Jun-2005 (the cell format is
mmm-yy and this date is linked to another diff sheet)

Because the date in cell A1 will change I have driven cell B1 from this cell
with the formula:

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

This therefore returns the date Jul-2005

and cell C1 returns Aug-2005 etc etc.

In sheet 2,

Cell A1 = 'Sheet 1'!A1 which returns Jun-2005
Cell B1 = 'Sheet 1'!B1 which returns Jul-2005

Now the issue I have is the next step.

In cell A2, i'm trying to do a formula that will return just '05' therefore
I use the formula:

cell A2 =RIGHT(A1,2) which returns '05'

In cell B2 though, i use the same formula;

cell B2 =RIGHT(B1,2) but it returns '34' regardless of cell format.

Is there a way to make sure this returns '05' as well?

Thanks for your help

Regards

Rich