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:
<tbody>
</tbody>
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:
<tbody>
</tbody>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....
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 |
<tbody>
</tbody>
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:
1/1/2017 |
6/1/2017 |
3/4/2017 |
3/5/2017 |
10/12/2017 |
29/11/2017 |
<tbody>
</tbody>
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....