Duration of 2 dates calculated with only business days

[perknation]

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?

[TheTimeSavingCo · Accepted solution]

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

WORKDAY_DIFF(Start,End)

[perknation]

Yep, that's it. Thanks!

[CTS]

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

[TheTimeSavingCo]

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