Results 1 to 6 of 6

Date caluclator to exclude weekends

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Date caluclator to exclude weekends

    I have a spreadsheet that calculates a future date based on a fixed start date, by inserting the number of weeks you would like it to project.

    I.e

    Start Date: 01/01/2011 (Saturday)
    No Weeks: 14
    End Date: 09/04/2011 (Saturday)

    I use this to arrange appraisal interviews.

    Now if someone starts work for us on either a Saturday or Sunday, the calculation will naturally show a Saturday or Sunday date, however many weeks into the future.

    We don’t interview at the weekends so Id like the calculator to show the first Monday date following a Saturday or Sunday. In this example it would be 11/04/2011. Also if the formula could display the Day of the week that would be better, i.e Monday 11/04/2011

    Can any one help.

    Sample sheet attached.

    Brian
    Attached Files Attached Files
    Last edited by singerbatfink; 09-01-2011 at 05:29 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