Results 1 to 4 of 4

Thread: 5 Day Week

  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: 5 Day Week

    Hi I've got 2 dates, I want to extract one from the other to get a total number of working days (mon - fri) but want to exclude weekends.

    Can anyone help?

    Thanks

    Matthew

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Perhaps a little more information will be helpful. Which cells are the two dates in? What is the format of each? Where are you wanting to put the results?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Mar 2004
    Posts
    36
    doesn't matter anymore

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    How did you resolve it? Sometimes people come here and can learn from what you have asked AND how you resolved it.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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