Skip to main content
Solved

Dates

  • March 20, 2024
  • 2 replies
  • 13 views

Forum|alt.badge.img+3
  • New Participant
  • 2 replies

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

Best answer by TheTimeSavingCo

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?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6454 replies
  • Answer
  • March 20, 2024

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?


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 2 replies
  • March 21, 2024

Thanks!!! Workday _diff works!!