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)).