INDEX MATCH that compares if date is between two dates and returns yes or no

**jjoseph08** · 02-15-2022, 12:44 PM

I'm trying to create a spreadsheet to eliminate hours of manual data entry, but I'm very new to using INDEX and MATCH. I'm trying to make it so the Jan-Mar sheet looks through the data dump sheet for employee names and the date a task was completed, then if the date falls between two dates on the date ranges sheet, return a yes or no on the corresponding week on the Jan-Mar tab.

I've been scouring forums for hours now and can't quite get it right.

**6StringJazzer** · 02-15-2022, 01:07 PM

Please see solution attached. However, note that in many cases an employee has more than one date that falls in a week. So you will get a Yes if the employee has completed one or more tasks that week.

You were on the right track with INDEX and MATCH but it's a bit more complicated. When asking a question it is best to tell us your inputs and desired results, and avoid telling us how you think it should be done.

=IF(COUNTIFS('Data Dump'!$A:$A,$A3,'Data Dump'!$B:$B,">="&INDEX('Date Ranges'!$B:$B,MATCH(B$2,'Date Ranges'!$A:$A,0)),'Data Dump'!$B:$B,"<="&INDEX('Date Ranges'!$C:$C,MATCH(B$2,'Date Ranges'!$A:$A,0)))>0,"Yes","No")

INDEX MATCH that compares if date is between two dates and returns yes or no

LinkBack

Thread Tools

Rate This Thread

Display

INDEX MATCH that compares if date is between two dates and returns yes or no

Re: INDEX MATCH that compares if date is between two dates and returns yes or no

Thread Information

Users Browsing this Thread

Similar Threads

Help with INDEX MATCH that returns next date when no further dates exist

Index Match Formula that Returns Most Recent Date

[SOLVED] Macro that compares 2 dates. I need to extract just date, first

[SOLVED] Trying to calculate- compares two dates, chooses later date, tells days to current date

[SOLVED] IF date value returned from Index/Match is blank, return prior cell that returns a value

Calculate month to date returns, index and match

[SOLVED] Function that compares dates and returns TRUE or FALSE

Bookmarks

Bookmarks

Posting Permissions