+ Reply to Thread
Results 1 to 1 of 1

Calculating Business Days by excluding Saturdays/Sundays and other Public Holidays

  1. #1
    all4excel
    Guest

    Calculating Business Days by excluding Saturdays/Sundays and other Public Holidays

    Calculating Business Days by excluding Saturdays/Sundays and other Public Holidays

    I am preparing an Attendance Report where I need to keep a track of all the Non-working days in each month such as Public Holidays and Weekends.

    I did try using the Workday but did not get the desired result...

    Can someone please help.....

    Have attached a file for reference....

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Check this one:

    http://www.cpearson.com/excel/DateTimeWS.htm
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1