+ Reply to Thread
Results 1 to 2 of 2

NETWORKDAYS Formula - Need Actual Date Rather Than # of Days

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    Arlington, VA
    MS-Off Ver
    Excel 2010
    Posts
    1

    NETWORKDAYS Formula - Need Actual Date Rather Than # of Days

    I'm using the NETWORKDAYS formula to determine the total number of days between a project's start date and the end dates of each task/deliverable. This populates into a Gantt chart I have on a dashboard to track the project. Anyone know how I can have the formula return the actual date rather than # using this formula? Assume it is some kind of IF nested formula, but I've been looking for clues online for hours and can't figure it out for the life of me.

    Formula right now is: =NETWORKDAYS($D$48,F7,0)

    $D$48 - Project Start Date
    F7 - End Date of 1st Task/Deliverable

    If I can get the formula to return the actual date, my Gantt chart should show the x axis timeline as dates rather than workdays. Or at least that is what I'm hoping for.

    Thanks for any guidance or help!

    JCrew

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: NETWORKDAYS Formula - Need Actual Date Rather Than # of Days

    Hi,

    Not sure what you mean by the 'Actual Date'. Actual date of what?

    If you just want to find the date that's the number of networkdays after the start then =D48+NETWORKDAYS($D$48,F7,0)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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