Re: Previous month's last business day

[joeljoel]

Daddylonglegs - someone turned me on to this thread and this formula a possible solution to my problem. I am curious what the TODAY() part does in the formula? Is this formula only going to work on a rolling basis? I am looking for something that will work calculate last two working days each month. I already have a column (column G) that numbers the working days each month (for the whole decade) and a list of holidays in column M. Now in column H I need the formula to identify those last 2 days and return a value (let's say "1"). Will your formula work? Or will it need tweaking?

Thanks!!