I need to automate a report that requires me to calculate the current business day of the month. For example, today is June 27, so it is the 19th business day of the month. I need it to update everyday itself, and I am stumped. Thanks so much whoever can help!!!

Hi,

Either of these formulae will do it, where C3 contains the date in question (eg. 27 June 2011):
If you are using Excel 2003 or earlier then the Analysis Toolpak must be installed.

These formulae only take weekends into account. If you want bank holidays to be included then you can - you'll need to define a range where you keep a list of bank holidays and then pass a reference to it into the 3rd, optional parameter of the NETWORKDAYS function.

Thanks!!! worked perfectly!