Hi,

I have a formula that looks at a date and determines if an action has occured on or after that date and returns the name of the client, I need to formula to look at 2 dates (start of the month and end of the month) and determine if an action has fallen either on those dates or between those dates and return a name.

the formula is as follows

=IFERROR(INDEX(Appointments!E:E,SMALL(IF([B]Appointments!$G$5:$G$1232>=$AJ$7,IF(Appointments!$B$5:$B$1232=1,ROW(Appointments!$B$5:$B$1232))),ROWS(AM$10:AM10))),"")

the date lookup is AJ7 (currenntly the start of the mont, the list of dates to lookup are G5 to G1232, all other parts of the formula work great I just cannont get it to use a start and end date as the lookup values.

Thanks in advance

JD