Hello,
I have a document that has a specific Date in cell A1. the date is dynamic based on other variables but are not needed for this example. I also have Dates in B1: ?? based on the month in A1 (i.e A1= 6/8/2014, B1= 6/1/2014 C1=6/2/2014 -> 6/30/2014).
I am wanting to create a formula that will count the column that matches cell A1 with al the matches to the value in cell A2 (A2= X).
Please let me know if i need to clarify my question. Im guessing i will have to do some sort of countifs and match combination, but cant quite figure it out.
Thank you!