business days in Excel

hb0983

New Member
Joined
Nov 9, 2005
Messages
16
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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,376
Office Version
  1. 365
Platform
  1. Windows
Take a look at the WORKDAY function in Excel help. This will exclude weekends, and any holidays you designate.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,016
Messages
5,569,628
Members
412,284
Latest member
Daibear
Top