+ Reply to Thread
Results 1 to 3 of 3

Working days of week

  1. #1
    Registered User
    Join Date
    10-19-2006
    Posts
    29

    Working days of week

    Hi

    I'm looking to have a list of working days only e.g:
    Thursday 12th April
    Friday 13th April
    Monday 16th April

    I would like to do this so it's done automatically, i.e.
    Thursday 12th April
    =A1+1
    =A2+1

    Is there a formula to do this?

    Thanks!!

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    Crispie, try this :

    Enter a date in A1
    Type (or copy) the next formula in A2 :
    Please Login or Register  to view this content.
    Now you can copy this formula down. Don't forget to set the right format.

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    If you don't mind using Analysis ToolPak add-in you can also use WORKDAY function, i.e.

    =WORKDAY(A1,1)

    you can also add a holiday range as the third argument of WORKDAY to exclude holidays also......

+ 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