Given a start date and end date, how do you calculate duration?

1

Hello. How do you do this?
You have a table. It has start dates and end dates.
I want a number of days.
This post didn’t help.
Looking up formulas for “Duration” was mystifying.

2

dear @Rezwan_Razani ,

file upload seems not to work

thisRow.[End Date] - thisRow.[Start Date]

Cheers, Christiaan

3

Thanks! That works! As a simple Text column type with a formula.

I’m still confused about what the “Duration” Column type is. I would have thought that you could choose that as your column type, and in the Column Options put in your start and end dates for it to calculate. But that doesn’t work at all.

Many unexpected things happen when playing around with the Duration options, and there’s no explanation of how that works anywhere. Well, just some cryptic explanations with no context or example.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.