Help

Dates

Solved
Jump to Solution
680 2
cancel
Showing results for 
Search instead for 
Did you mean: 
evi
5 - Automation Enthusiast
5 - Automation Enthusiast

I have created a table with days off of the team. BUT for instance a person takes 2 days (22-23//24) the airtable count it as 1 day. Is there any other way to count is as 2 cuase actualy the person will be off 22 and 23.

Thank you

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Are you able to use "WORKDAY_DIFF" instead?  That appears to work the way you want:

Screenshot 2024-03-20 at 11.38.42 PM.png

Link to base

If not, perhaps you could just do a +1 to your DATETIME_DIFF?

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Are you able to use "WORKDAY_DIFF" instead?  That appears to work the way you want:

Screenshot 2024-03-20 at 11.38.42 PM.png

Link to base

If not, perhaps you could just do a +1 to your DATETIME_DIFF?

evi
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks!!! Workday _diff works!!