Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2017, 09:57 AM
schmil schmil is offline Date diff in workdays Windows 10 Date diff in workdays Office 2016
Novice
Date diff in workdays
 
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 Date diff in workdays Windows 7 64bit Date diff in workdays Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
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 Date diff in workdays Windows 10 Date diff in workdays Office 2016
Novice
Date diff in workdays
 
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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date diff in workdays 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
Date diff in workdays 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
Date diff in workdays Diff two Templates ? exoson Word 7 01-20-2014 05:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft