Choose last but one date

[simotrab]

Hi community,

short question about dates: how could I choose the last but one date from a group of date?

The formula I need is something like

today()-LastButOneDate()

Thanks in advance!

[Gysbert_Wassenaar · Accepted solution]

Perhaps like this: Today() - Max(YourDateFieldHere, 2)

[simotrab]

Thanks a lot!