I have a very large database for new and current customers. I am trying the figure the number of times a new customer has placed an order in the previous 365 days.
For example, assume the new client has placed an order on the following 5 days:
03/28/2013
12/25/2013
03/05/2014
03/12/2014
04/08/2014
If I were asked on 4/8/14 how many orders has the new client made in the past 365 days from 4/8/14, including 4/8/14, the answer would be 4. It is 4 because the order on 3/28/13 is more 365 days from 4/8/14. I also want to display the oldest order, which would be the first order within 365 days from most recent order. In this case, the oldest order within 365 days of 4/8/14 is 12/25/13
Not sure if there is way to do this, but I have attached a sample spreadsheet with desired output. Desired output for Orders Received in Last 365 Days is in column G. Desired output for the Oldest Order within 365 days of Current Order is in column H. Thanks.
Bookmarks