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



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 04:41 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