#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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" |
|
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 |