Hi All,
I need a formula which will tell me how many dates I have data for during a week number.
Column B is the week number, Column C is the Date, I may have for example 20 different rows of data all from the 18/4/17 which all occurred in week 16, I want to be able to put in a formula that counts all the different dates entered along side Week 16 and tells me how many different ones there are.
Thankyou!
I need a formula which will tell me how many dates I have data for during a week number.
Column B is the week number, Column C is the Date, I may have for example 20 different rows of data all from the 18/4/17 which all occurred in week 16, I want to be able to put in a formula that counts all the different dates entered along side Week 16 and tells me how many different ones there are.
Thankyou!