Yo Airtable Dev! You guys are doing amazing stuff…
I’d like to request, as the title suggests, adding ‘weekdays’ as a DATETIME_DIFF ‘unit’
I’m writing a simple PTO log and request form, in the longer view, to track annual PTO usage blah-blah-blah. I know, PTO is so anachronistic…
Anyway, right now I use a request form with a begin date and end date query fields but in this case it is also necessary to ask, ‘how many work-days will you be gone?’ Which is kind of weird.
I would automate this process with a DATETIME_DIFF() formula field in the log if I could but I’ve not been able to come up with a way to eliminate weekends from that duration. Which could always be user error. Admittedly
This is really the equivalent of a function in Excel called NETWORKDAYS(), which if that’s easier to implement, I’m all for that too.