Index match and vlookups

Hi,

I am familiar with knowing how to use the INDEX MATCH formula and VLOOKUPS.
However, I noticed I am not getting the desired result when working with dates.
For example, say column A contains dates written like 25/11/2013, 01/06/2011, 23/10/2020.
Column B has a header called "ID" it has a range of integer values like 6,34, 54,1,7,23 etc.
Now, I want to find the ID(which is in column B) associated with the date(which is in column A).

So, I was typing =INDEX("A1:C500",MATCH("25/11/2013",A:A,0),MATCH("ID",A1:C1,0))
but I am getting #n/a when I can clearly see from my excel spreadsheet the ID linked to 25/11/2013 is 5.

Any ideas?

Thanks

If "date" in column A is text format

=INDEX(A1:C500,MATCH("25/11/2013",A:A,0),MATCH("ID",A1:C1,0))

If "date" in column A is date value
=INDEX(A1:C500,MATCH(DATE(2013,11,25),A:A,0),MATCH("ID",A1:C1,0))