Prev: VLOOKUP formula displays in cell, will not return data
Next: date check with exchange rate
From: mars on 12 May 2010 14:47
Hello
Can anyone help on this small query.
I want to enter a year in a cell in this format "2006/07"
I have several cells linked to this which will then populate in steps
i.e. based on the year I have entered they will increase annually thus
2007/08, 2008/09 et seq.
Can this be done?

Many thanks

Mars
From: Gord Dibben on 12 May 2010 16:15
There may be easier ways to do this but..........

With 2007 in A1

Enter in B1 =LEFT(A1,2)&RIGHT(A1,2)&"/"&TEXT(RIGHT(A1,2)+1,"00")


Gord Dibben MS Excel MVP


On Wed, 12 May 2010 11:47:45 -0700 (PDT), mars <hifrommars(a)hotmail.com>
wrote:

>Hello
>Can anyone help on this small query.
>I want to enter a year in a cell in this format "2006/07"
>I have several cells linked to this which will then populate in steps
>i.e. based on the year I have entered they will increase annually thus
>2007/08, 2008/09 et seq.
>Can this be done?
>
>Many thanks
>
>Mars

From: mars on 12 May 2010 17:20
Thanks Gord worked beautifully

Mars
From: Gord Dibben on 12 May 2010 17:40
Thanks for the feedback.

Gord

On Wed, 12 May 2010 14:20:00 -0700 (PDT), mars <hifrommars(a)hotmail.com>
wrote:

>Thanks Gord worked beautifully
>
>Mars

From: Bernd P on 13 May 2010 02:05
On 12 Mai, 21:15, Gord Dibben <gorddibbATshawDOTca> wrote:
> There may be easier ways to do this but..........
>
> With 2007 in A1
>
> Enter in B1   =LEFT(A1,2)&RIGHT(A1,2)&"/"&TEXT(RIGHT(A1,2)+1,"00")
>
> Gord Dibben  MS Excel MVP
>
> On Wed, 12 May 2010 11:47:45 -0700 (PDT), mars <hifromm...(a)hotmail.com>
> wrote:
>
> >Hello
> >Can anyone help on this small query.
> >I want to enter a year in a cell in this format "2006/07"
> >I have several cells linked to this which will then populate in steps
> >i.e. based on the year I have entered they will increase annually thus
> >2007/08, 2008/09 et seq.
> >Can this be done?
>
> >Many thanks
>
> >Mars

Try 1999 or 2099.
=LEFT(A1,2)&RIGHT(A1,2)&"/"&TEXT(RIGHT(RIGHT(A1,2)+1,2),"00")

Regards,
Bernd
 |  Next  |  Last
Pages: 1 2
Prev: VLOOKUP formula displays in cell, will not return data
Next: date check with exchange rate