Results 1 to 5 of 5

Working days

Threaded View

  1. #3
    Registered User
    Join Date
    09-18-2007
    Posts
    30
    Thanks for that. I assume it counts in the dates given as well so to get a "five working day apart from the day request was taken" I simply put a -1 in at
    =SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1-1)/7))

    It works, and gives me the correct answer, but there's a little green triangle on the top left of the box which gives an "inconsistent formula message", is it ok to just mark it as ignore?
    Last edited by Huwbob; 09-19-2007 at 09:39 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