Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Unanswered: Calculate Excel Business Days

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

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    Either of these formulae will do it, where C3 contains the date in question (eg. 27 June 2011):
    Code:
    =NETWORKDAYS(EOMONTH(C3,-1)+1,C3)
     
    =NETWORKDAYS(DATE(YEAR(C3),MONTH(C3),1),C3)
    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.
    Last edited by Colin Legg; 06-28-11 at 11:31.

  3. #3
    Join Date
    Jun 2011
    Posts
    2
    Thanks!!! worked perfectly!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •