Hmm, what if you used WORKDAY_DIFF
, put in the holidays, and then divided that result by 5?
Documentation

This is great, thank you! I missed a critical point, sorry - Would there be a possibility for something that counts in real time so you know what week you’re in? We have certain milestones in week 7, 11 and 16 of work so keeping track of that week is important too. And because each staff member has a different start date (and sometimes gets the different holidays) it needs to be unique for everyone.
This is great, thank you! I missed a critical point, sorry - Would there be a possibility for something that counts in real time so you know what week you’re in? We have certain milestones in week 7, 11 and 16 of work so keeping track of that week is important too. And because each staff member has a different start date (and sometimes gets the different holidays) it needs to be unique for everyone.
Hmm, if it’s real time, I guess WEEK(TODAY())
, which would give you a field that shows you today’s week number?
Sorry, I’m pretty sure I’m misunderstanding something. How would you use that data?