Hi, i have several columns with dates and a reference column with dates as well. I need a formula in a row A-Z which will lookup the date in columns A-Z and match it against the reference date column and if they match return the count for me in a particular cell that I have the formula in. see example below
Example:
Column A Column B Column (C-Z) Reference Date
1/1/15 1/1/15 ... 1/2/15
1/3/15 2/1/15 ... 2/1/15
1/8/15 2/2/15 1/8/15
3/1/15 2/5/15 2/5/15
1/18/15 2/8/15 1/18/15
1/25/15 1/23/15 1/23/15
Result Result Results
2 3
Example:
Column A Column B Column (C-Z) Reference Date
1/1/15 1/1/15 ... 1/2/15
1/3/15 2/1/15 ... 2/1/15
1/8/15 2/2/15 1/8/15
3/1/15 2/5/15 2/5/15
1/18/15 2/8/15 1/18/15
1/25/15 1/23/15 1/23/15
Result Result Results
2 3