Help

Duration of 2 dates calculated with only business days

Topic Labels: Formulas
Solved
Jump to Solution
633 4
cancel
Showing results for 
Search instead for 
Did you mean: 
perknation
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2023-04-26 at 1.25.41 PM.png

WORKDAY_DIFF(Start,End)

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2023-04-26 at 1.25.41 PM.png

WORKDAY_DIFF(Start,End)

Yep, that's it. Thanks!

CTS
4 - Data Explorer
4 - Data Explorer

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