Results 1 to 5 of 5

How to change change formulas such that formula is based on Work Days rather than Days

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2021
    Location
    Washington, DC
    MS-Off Ver
    Microsoft Office 2016
    Posts
    10

    How to change change formulas such that formula is based on Work Days rather than Days

    Hi Excel Forum members,
    I have a schedule that has formulas that calculate end dates based on the number of days (including weekends) that a task takes to complete. Entering in the number of days calculates the end date as well as the number of work days to finish the task. However, I want to do the opposite such that (with the same start and end dates, except cells C10 and C28 which should be Monday and Friday, respectively) entering in the number of work days spits out the number of days (including weekends) a task would take to complete. Would anyone have any suggestions on how to do this? Furthermore, regarding cells C10 and C28, would anyone know a formula that adds the next working day to a date rather than calendar day? Please see the attached sample spreadsheet.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to calculate task schedule based on 4-days work and 4-days OFF including weekends
    By qadeerume in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-28-2020, 12:19 AM
  2. Calculate % change based on a chosen amount of days
    By Alexmedft in forum Excel General
    Replies: 14
    Last Post: 07-27-2017, 08:52 AM
  3. [SOLVED] Change your Calendar work days and the start of your week Excel 2010
    By jason.hampton in forum Excel General
    Replies: 4
    Last Post: 08-08-2015, 09:58 AM
  4. Change Start dates upon duration days change in Project timeline calculation.
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2015, 10:28 AM
  5. Change Font Color for whole ROW based on 30, 60, 90 days out
    By onelovesojah in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2015, 04:46 PM
  6. Replies: 10
    Last Post: 09-25-2012, 09:24 AM
  7. Replies: 0
    Last Post: 09-20-2012, 12:05 PM

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