Forum Discussion
Retrieving date of only next occurrence
Hi Dear;
I have a list of date sorted data with some events happening multiple times...
Example; Customer ABC12345678 doing purchase with us occasionally... from the last purchase date and till today when customer did purchase again; i want to show the next purchase date with previous purchase in the table to count days between transactions...
2 Replies
shahzad_afzal Assuming your list is sorted by date (ascending) and if your Excel version supports XLOOKUP, please find a possible solution in the attached workbook.
Examble:
Customers Last Buy New Buy Days +/- ABC12345678 01.10.2020 28.10.2020 27 Formula is =DATEDIF(E3;F3;"d")
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
