Forum Discussion
ElaineABsg
Feb 21, 2022Copper Contributor
2nd last purchase date
Hi i hope to check either by pivot or formula how to get the 2nd last purcase date of a customers. I get the 1st date of purchase from min, max for last purchase date. But stuck on the above issue....
SergeiBaklan
Feb 21, 2022Diamond Contributor
You may use =LARGE(dates, 2). Just in case, =LARGE(dates,1) is equivalent of =MAX(dates).
If you have any conditions it'll be bit more complex formula, but the basis is the same.
ElaineABsg
Feb 21, 2022Copper Contributor
Ok thks Sergei 😉