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