Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-16-2017, 09:57 AM
schmil schmil is offline Windows 10 Office 2016
Novice
 
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
  #2  
Old 05-16-2017, 01:03 PM
Guloluseus Guloluseus is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 132
Guloluseus is on a distinguished road
Default

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
  #3  
Old 05-16-2017, 11:39 PM
schmil schmil is offline Windows 10 Office 2016
Novice
 
Join Date: May 2017
Posts: 3
schmil is on a distinguished road
Default

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
Reply
Please reply to this thread with any new information or opinions.

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 12:30 PM.


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