- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 20, 2024 05:14 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 20, 2024 08:39 AM
Are you able to use "WORKDAY_DIFF" instead? That appears to work the way you want:
Link to base
If not, perhaps you could just do a +1 to your DATETIME_DIFF?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 20, 2024 08:39 AM
Are you able to use "WORKDAY_DIFF" instead? That appears to work the way you want:
Link to base
If not, perhaps you could just do a +1 to your DATETIME_DIFF?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2024 01:26 AM
Thanks!!! Workday _diff works!!
