Skip to main content

I'm trying to use the datetime_diff formula to configure a field similar to the ootb duration field in Smartsheet, but in Airtable.

I have a start-date and and end-date field. My goal is to have a duration field show the number of days between the start and the end dates.

Here are my constraints. 1) I want to be able to show only weekdays. 2) If the start date and the end date are the same I want the duration to equal 1, not 0.

Any suggestions?

You can use `WORKDAY_DIFF()` for that I think:

WORKDAY_DIFF(Start,End)

You can use `WORKDAY_DIFF()` for that I think:

WORKDAY_DIFF(Start,End)

Yep, that's it. Thanks!

how if the start date and end date falls in different month for this case? Thank you in advance.

how if the start date and end date falls in different month for this case? Thank you in advance.


@CTSI think it'll work fine even if they have different months

Reply


Terms & Conditions