Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

LinkBack Thread Tools Display Modes
Old 05-16-2017, 09:57 AM
schmil schmil is offline Windows 10 Office 2016
Join Date: May 2017
Posts: 3
schmil is on a distinguished road
Question Date diff in workdays

Hi I am search for a formula to build a column, that gives me the remaining workdays to the end of a task. Some ideas?
Reply With Quote
Old 05-16-2017, 01:03 PM
Guloluseus Guloluseus is offline Windows 7 64bit Office 2010 32bit
Competent Performer
Join Date: Mar 2013
Posts: 154
Guloluseus is on a distinguished road

It depends on exactly what you want to calculate. set up a new column and define it as a number (so use insert column, and choose "number1", "number2" or whichever one you prefer) then;
If its time remaining from todays date, use the formula

IIf(([Finish]-[Current Date])>0,([Finish]-[Current Date]),0)

the IIf statement means that you will get a 0 in the column if the task has no days left.

If you want it to show in whole days (depending on the way project is set up, it may well give a decimal because of the time being seen as a fraction of a day), try
CInt(IIf(([Finish]-[Current Date])>0,([Finish]-[Current Date]+1),0))

or CInt(IIf(([Finish]-[Current Date])>0,([Finish]-[Current Date]),0)) ; this will give number of days rounded down (first one) or rounded up(second).

If you want to show number of days from the status date, then use [Status Date] instead of [Current Date]

If none of these fit the bill, let us know and I can work some new ones
Reply With Quote
Old 05-16-2017, 11:39 PM
schmil schmil is offline Windows 10 Office 2016
Join Date: May 2017
Posts: 3
schmil is on a distinguished road

I am looking for a formula that will give me the "working days".
E.g. today is Wed 17th, project end is Mo 22th. The diff should be: "3 work days"
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date diff in excel 2007 otuatail Excel 10 04-15-2017 05:33 AM
Add workdays to start date, inluding saturdays and holidays CHAVITA Excel 3 01-04-2016 12:57 PM
Workdays since Received Odyssey Outlook 2 12-07-2014 04:37 PM
set daily goal for actual workdays, excluding weekends holidays and days off Brian Reilly Excel 1 01-24-2014 11:56 PM
Diff two Templates ? exoson Word 7 01-20-2014 05:09 PM

All times are GMT -7. The time now is 02:16 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft