Counting Days
On Thu, 17 May 2012 09:22:11 +0000, rajeshv19 wrote:
Hello All,
Might need some help here..I have a series of customer lists, i.e.
Account no. along with transaction dates. The list looks like this,
Account Transaction Dates
750002 29/04/2010
750002 27/07/2010
750004 25/02/2010
750004 03/03/2010
750004 20/04/2010
750004 27/04/2010
Column A – Account and Column B- Transaction Dates.
What I wanted to find is number of days between first, second and third
transactions by an account. This is to gauge what are the dates between
his purchases. Assuming I have a list of close to 30k customers who
could have one/ ten transaction dates against them, it would be great to
have a formula to do this trick.
Cheers
Please provide an example of your desired output.
To obtain the number of days between dates, merely subtract the earlier date from the later date.
|