I'm trying to create a field for my tasks list which show the number of weekdays between two dates. This is what I have atm: DateDiff("d",[Start Date],[Due Date])+ 1
According to help, the appropiate interval to use is "w", but this is just counting the number of whole weeks. "ww" is counting the number of whole or partial weeks. "d" counts days inluding weekends. What is the appropriate interval to use to count weekdays?
Once I've got that working, I'd like to complicate it even further. This semester I'll be working 4 days a week. Is it possible to set it up to count weekdays, not including thursdays?
According to help, the appropiate interval to use is "w", but this is just counting the number of whole weeks. "ww" is counting the number of whole or partial weeks. "d" counts days inluding weekends. What is the appropriate interval to use to count weekdays?
Once I've got that working, I'd like to complicate it even further. This semester I'll be working 4 days a week. Is it possible to set it up to count weekdays, not including thursdays?