Hi all,

i need help on the below question.
i have a leave tracker that i have prepared, in which it shows me all the dates that my staff have applied for leave.
example in Column A and B, i have the below dates, where column A is the start date and column B is the end date, in File A:
23/11/2017 28/11/2017
1/5/2017 1/6/2017
3/4/2017 5/4/2017
5/1/2017 7/1/2017
9/3/2017 11/3/2017

i also have a separate file where keep daily records of their attendance, in file B, say column C is where i keep the dates, example:

so now i need to check if dates in column C in file B, falls under any dates within A:B in file A, for leave reconciliation.
i tried to use the IF formula, which it would only compare within the same row. however i need C1 to compare with all A1:B5 (or even more data when the list expands)..

anyone can help?

sorry if i have not explained it clearly....