Find If A Month Falls Within A Range of Months

**DBB1** · 12-02-2022, 07:07 PM

I am currently extracting the month from the LATEST date that appears in a column of dates. I would like to then perform an action if that month falls within a pre-defined range of months - day and year are not important, but the range of months could span into the following year, so it's not a contiguous range of Jan to Dec.

For example, I have determined that "Nov" (or 11) is the month of the latest date that appears in my date column. I want a cell location to get the value of "6" if "Nov" falls within my target range of "Sep" thru "Feb." Numerically speaking, does 11 fall within the range of 9, 10, 11, 12, 1, and 2, and if so, put a 6 in a cell location?

I do not yet have the 9 - 2 range of months defined anywhere.

How would I go about doing this?

**6StringJazzer** · 12-02-2022, 11:29 PM

A1 = month number of first month in target range
B1 = month number of last month in target range
C1 = month number of latest date

=IF(A1>B1,OR(AND(C1>=A1,C1<=12),AND(C1>=1,C1<=B1)),AND(C1>=A1,C1<=B1))

This gives TRUE or FALSE to indicate whether it's in the range. I don't see where you are getting 6 from.

**DBB1** · 12-05-2022, 04:24 PM

Thanks for responding so quickly! I'm testing your solution out with my scenario.

(The "6" is just an internal value I want to put into a cell if those monthly conditions are met.)

**6StringJazzer** · 12-05-2022, 06:55 PM

OK then

Formula:

Please Login or Register  to view this content.

Find If A Month Falls Within A Range of Months

LinkBack

Thread Tools

Rate This Thread

Display

Find If A Month Falls Within A Range of Months

Re: Find If A Month Falls Within A Range of Months

Re: Find If A Month Falls Within A Range of Months

Re: Find If A Month Falls Within A Range of Months

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Number of times a month/day falls on a certain day-of-week within a range of years

Calculate Number of weeks/months falls under each year between date range

[SOLVED] Count Occurrences Date Range Falls Within Month

[SOLVED] Extract value or sum total based on month criteria that falls within Data Range

Return True or False if date range falls within current month

[SOLVED] Determine number of months that falls within a given range within two other dates

Find which range a name falls into?

Bookmarks

Bookmarks

Posting Permissions