Question

Dear Sir/Madam,

I want to calculate the number of days between my last workout and the previous one. I've searched and tried all my best but still cannot find any solution.

Please advise if that's possible to use formula or other methods.
Here is an example of my workout tracking which I'm currently input the number of days manually.

Row 1:
Prop: Date of workout = 2024-04-01, Prop: Days between (Dates in row 1 and row 2)

Row 2:
Prop: Date of workout = 2024-04-03, Prop: Days between (Dates in row 2 and row 3)

Thank you so much for your help.

Best regards,

PKG

Answer 1

So you would need to find the "Max" date in the database and base your calculation on that date?

I haven't been able to find more information on how you might do this. But it seems like the thing to try would be a separate database relation that captures the "Max date" from your workout database? And then you can call on that? That's the rabbit hole I was about to dive down before I realized that that probably is not a great use of my time.