Hi All,
How could I write a formula that return the last work day of an input month?
Thanks in advance!
Simon
For example,
July 31st, 2021 is a Saturday --> return July 30th,2021
June 30th, 2021 is a Wednesday --> return June 30th, 2021
February 28th, 2021 is a Sunday --> return February 26th, 2021
Solved! Go to Solution.
Wow! Thanks for the quick response and the neat solution!
Happy to help : ) @skong
If my response helps please don't forget to mark it as solution.
Cheers and have a nice day!
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |