Locate month and year from range of date from another sheet
 

Hi all,
I want to locate month and year from range of date through April, 05 to
Feb.,06
How?

Thanks and regards

RRS

Locate month and year from range of date from another sheet
 

=MONTH(A1)

will return the index number of the month, e.g. 01/01/06 in A1 will return 1

=YEAR(A1)

will return the year

if you want the month in text like January

=TEXT(A1,"mmmm")

or just

=A1 and custom format mmmm


--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Rao Ratan Singh" wrote in message
...
Hi all,
I want to locate month and year from range of date through April, 05 to
Feb.,06
How?

Thanks and regards

RRS

Locate month and year from range of date from another sheet
 

These may be helpful...

=TEXT(A1,"mmmm")
=YEAR(A1)

Vaya con Dios,
Chuck, CABGx3



"Rao Ratan Singh" wrote:

Hi all,
I want to locate month and year from range of date through April, 05 to
Feb.,06
How?

Thanks and regards

RRS

Locate month and year from range of date from another sheet
 

I just want to locate mmm, yy from my Sales book Sheet range of date which is
from 4/01/05 to 2/28/06 in other sheet which have 12 rows for month column
sequentially.

For Example -
b9 should be Apr-05
b10 should be may- 06

it should be in date format not in text