Hi,
Appreciate your help with the following formula which is not working as I would want:
Essentially, I would need to count only those dates in column M which are smaller than the date noted in cell Z2
I have the following issues:
1. Z2 is formatted as Date, format 01 Jan 2000. This cell in itself is an INDEX/MATCH output from exported source though. At the same time, column M on Source tab is formatted as Custom, 01-Jan-2020 (and is also an export from another source). Changing that would be problematic as the inputs are dynamic. I need to somehow compare the values even though the format is different, if at all possible.
2. I'll need the formula which can be pulled down across the whole column, i.e. next cell matching Z3 and so on.
Appreciate your help with the following formula which is not working as I would want:
Excel Formula:
=COUNTIFS('Source'!$E$13:$E$15000, C2, 'Source'!$M$13:$M$15000, "<Z2")
I have the following issues:
1. Z2 is formatted as Date, format 01 Jan 2000. This cell in itself is an INDEX/MATCH output from exported source though. At the same time, column M on Source tab is formatted as Custom, 01-Jan-2020 (and is also an export from another source). Changing that would be problematic as the inputs are dynamic. I need to somehow compare the values even though the format is different, if at all possible.
2. I'll need the formula which can be pulled down across the whole column, i.e. next cell matching Z3 and so on.