business days in Excel

[hb0983]

Hello,

I am trying to always return the last business day in a cell. Currently I am using =today()-1 and using =weekday and some if statements to get to this. The problem is this won't take into account public holidays and is quite messy.

Does anyone know if there is an excel function or an easier way.

Many thanks,

Henry

 

[Joe4]

Take a look at the WORKDAY function in Excel help. This will exclude weekends, and any holidays you designate.