Forum Discussion

MCAdmin's avatar
MCAdmin
Qrew Member
4 years ago

Formula to Calculate 3rd working day of a month

Hello all,  I am looking for a formula which will help me determine 3rd working day of a month taking into account week-ends if any and list of public holidays. I have list of public holiday dates ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
@MC Admin  I don't have a formula handy for that but I could work with you one on one to get it working.   Contact me by the email in my signature line if you like. Detecting holidays will need to use a table of holidays and a formula query.  We would also need to detect consecutive holidays if that is a possibility. ​

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------