Hi all,

New to the forum so hope that someone can give me a bit of guidance. Thanks in advance.

I dont have a programming background so I was looking for the most simple solution to the following problem.

I want to determine whether a month (i.e. July) falls between two date ranges (1-7-2018 and 1-9-2018). Is this something that can be done??

Just for those more visually inclined:


D E M N O
4. July
488. 123,456
491. 1-7-2018 1-9-2018
500. 123,456

Q. Does July (N4) sit between these two dates(D491 and E491)? If yes, how do I have it spit out a value into cell o500, such that if the date does fall between the ranges, then it provides the value of cell M4 in cell o500?

I've tried both of these to no avail. Am I on the right track?

- - Working within cell o500) - -

=IF(AND($N$4=D491, $N$4<=E491),"na", M491)

=if(and(month(N$4)=date($D488),month(N$4)<=date($ E488)),$M488,"na")

Any help would be appreciated.

Thank you!!!!