Hello. I have a spreadsheet that has a list of distributors across the top and dates down the side. I have an x in each date cell where the distributor ordered one of our products, like this:
A
2/12 x
2/13
2/14
2/15 x
2/16
2/17
2/18 x
I want to count the number of days in between when they ordered. In other words, for distributor "A", I want a formula that will count the number of days between 2/12 and 2/15, then the number of days between 2/15 and 2/18. Anybody have any ideas on the best way to do this? Your help would be very much appreciated!
A
2/12 x
2/13
2/14
2/15 x
2/16
2/17
2/18 x
I want to count the number of days in between when they ordered. In other words, for distributor "A", I want a formula that will count the number of days between 2/12 and 2/15, then the number of days between 2/15 and 2/18. Anybody have any ideas on the best way to do this? Your help would be very much appreciated!