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
Bookmarks