INDEX/MATCH Dates is returning #DATE EXPECTED

Jcuison

Hello! I am having trouble with the formula below. I am trying to run a compliance check and need to confirm if the clinics are completing their monthly assignments.

The clinics column is the primary list of all clinics at our organization and the reference column has an index/match formula pulling from another sheet to associate if the clinic actually completed their assignment. I am also trying to associate and match the date of the completed assignment, but I am getting an error for #DATE EXPECTED. I've already turned the column into a Date type so I am not sure why I am getting this message... See formula I was using below. Thank you in advance for guidance and assistance!

=IFERROR(INDEX({Ambulatory Manager's Continuous Readiness Range 2}, MATCH(Clinics@row, {Ambulatory Manager's Continuous Readiness Range 2}, 0)), "")

hollyconradsmith

Hi @Jcuison,

Is this range a date range: {Ambulatory Manager's Continuous Readiness Range 2}?

If not, revise the reference in your formula immediately following the INDEX to reference a date range from your referenced sheet.

INDEX( DATE RANGE , MATCH(etc...

Jcuison

Hi @hollyconradsmith,

Yes the following is a date range: {Ambulatory Manager's Continuous Readiness Range 2}.