Results 1 to 9 of 9

How to calculate (and remove) the number of weekend days between two date ranges

Threaded View

Gooford How to calculate (and remove)... 03-08-2012, 11:38 AM
Andrew-R Re: How to calculate (and... 03-08-2012, 11:40 AM
Gooford Re: How to calculate (and... 03-08-2012, 12:29 PM
mahju Re: How to calculate (and... 03-08-2012, 12:36 PM
NBVC Re: How to calculate (and... 03-08-2012, 12:38 PM
mahju Re: How to calculate (and... 03-08-2012, 12:55 PM
Gooford Re: How to calculate (and... 03-08-2012, 12:38 PM
dangelor Re: How to calculate (and... 03-08-2012, 01:02 PM
Gooford Re: How to calculate (and... 03-09-2012, 10:10 AM
  1. #1
    Forum Contributor
    Join Date
    09-17-2009
    Location
    Torquay, England
    MS-Off Ver
    Excel 2013
    Posts
    253

    How to calculate (and remove) the number of weekend days between two date ranges

    Hi,

    I need to keep record of the number of days people have off sick from work.

    I have a simple END DATE - START DATE formula but I need to ignore any non weekend days

    Is there a nice simple solution?

    Thanks
    Last edited by Gooford; 03-09-2012 at 10:11 AM.

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