WORKDAY help

[Richard_Hulbert]

Hi All,

I have worked my way through the threads relating to WORKDAY but can't seem to find an answer to my problem, which I know is probably very easy.

I have a simple holiday request form and I want to check if the start date (which will only be a "working day" e.g. not Sat or Sun) is less than 4 weeks ahead of TODAY() (which I think should be 20 working days??)

Hope this is enough info. If anyone can help that would be great.

Thanks in advance

Richard

[Steve · Accepted solution]

Untested, but I would think ([Start date] < WORKDAY(TODAY(), 20)).

[Steve · Accepted solution]

Untested, but I would think ([Start date] < WORKDAY(TODAY(), 20)).

[Richard_Hulbert]

Thank you Steve, I knew I was over thinking it! 😂

This is a pretty ordinary start / end date expression but I am not experienced in them (as you can see). Do you happen to know if anyone has published a list of "useful" real world date expressions, over and above the ones in the documentation?

Thanks again for your help

[Steve · Accepted solution]

The examples in the docs are mostly based on real-world needs. Beyond that, you can find plenty of examples here in the community. Is there a curated collection of useful expressions? Not to my knowledge. Feel free to ask about your specific interests. AI might also be helpful.

[Richard_Hulbert]

Thanks Steve