date ranges

[lovelyanai]

hello,

Can someone please help me figure this out: In column A I have dates in the format of 03/17/2011 for example. I need to put in the next column the name of the month based on these criteria....

Dates between January 25 and February 21 would be February
Dates between February 22 and March 24 would be March
Dates between March 25 and April 21 would be April
and so on throught the year till December

what formula can I use?

 

[T. Valko]

hello,

Can someone please help me figure this out: In column A I have dates in the format of 03/17/2011 for example. I need to put in the next column the name of the month based on these criteria....

Dates between January 25 and February 21 would be February
Dates between February 22 and March 24 would be March
Dates between March 25 and April 21 would be April
and so on throught the year till December

what formula can I use?

Create a 3 column table with the date intervals and the month name like this:

<TABLE style="WIDTH: 180pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=240 border=0 x:str><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688" span=2 width=84><COL style="WIDTH: 54pt" width=72><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 63pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=84 height=17>1/25/2011... </TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 63pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=84>2/21/2011... </TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=72>Feb</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>2/22/2011...</TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">3/24/2011... </TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">Mar</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>3/25/2011... </TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">4/21/2011... </TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">Apr</TD></TR></TBODY></TABLE>

Assme that table is in the range E2:G4.

Then:

A2 = some date

Enter this formula in B2:

=IF(OR(A2 < E2,A2 > F4),"",LOOKUP(A2,E$2:G$4))

 

[Trouttrap2]

Another alternative, if you don't want to build a helper table, is to use
=LOOKUP(D2-DATE(YEAR(D2),1,0),{1,25,53,84,112,145,173,206,234,268,295,329,356},{"Jan","Feb","Mar","April","May","June","July","Aug","Sep","Oct","Nov","Dec","Jan"})

D2 is your lookup value. Drag down.

 

[lovelyanai]

Thank you for the formual it worked like a charm

 

[olivia.ruiz82]

Thank you. I was able to use this formula to assist me with my problem. I'm trying to lookup dates from rows of data and return a monthsort number.