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 tod...
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.