Print months in nextcell basing on dates

[excelkeechak]

hi , i had a worksheet with cells containing dates in Column A.I want to print the months like APR or MAY depending upon the month returned by the date.
I had raised this query before.I got the answer saying to Use =Month() in the next cell containing the dates. But i m getting the wrong result.
whatever date is entered in the column A i m getting January as the result. What went wrong. I even formatted the cells with MMMM also .Kindly help me

[NBVC]

You can use just =A1 and format that as custom: MMMM

or use formula: =Text(A1,"MMMM")

where A1 has original date.

[excelkeechak]

Yeah,now i succeeded.what if had cut off dates like My Accounting Period starts from ;1-04-09 TO 20-04-2009 - APRIL
21-04-2009 TO 20-05-2009- MAY and so on.... what to do in this kind of situation

[NBVC]

Not sure what you mean..

What exactly is in the cell and what exactly do you want in next cell?

[excelkeechak]

I want to return the same thing(Months) but the starting & ending dates differ.when there is date between 01-04-2009 to 20-04-2009 should return April and so on.....

[NBVC]

So is this: "01-04-2009 to 20-04-2009" in one cell and you want the month for this part: "20-04-2009"? I am a little confused

[excelkeechak]

no no.if there are dates in between the date :01-04-2009 to 20-04-2009.it should return APRIL

for example: 06-04-2009 should return april like so on....

[NBVC]

Sorry... maybe it is basic.. but I am lost... I really don't understand your question.. hope someone else understands and can help...

Or perhaps post a sample workbook showing what you want.

[c.vaibhav]

Hi excelkeek,

Do you want it this way

A1 --------------------------------------------- A2

Date betn 01-04 to 20-04 ------------------ April
Date betn 21-04 to 20-05 -------------------May

Is this what you want??

Vaibhav

[excelkeechak]

Exactly as mr.vaibhav had told.sorry if i could not pose the question properly . i m tired working in the office

[NBVC]

Okay, I think I get it now...

First you would have a list of all the starting date ranges...

i.e.

1/04/09
21/04/09
21/05/09
etc..

then use formula:

=TEXT(LOOKUP(A1,X1:X100),"MMMM")

where X1:X100 contains dates list. and A1 contains date to match.

or you can use just

LOOKUP(A1,X1:X100) custom formatted as "MMMM"

[c.vaibhav]

Hi,

You can also use nested if loops.

I have attached the excel file.

Just enter the date in column G and column H updates the month.

Vaibhav