Microsoft Office Forums Date diff in workdays
 Register FAQ Search Today's Posts Mark Forums Read

#1
05-16-2017, 09:57 AM
 schmil Windows 10 Office 2016 Novice Join Date: May 2017 Posts: 3
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
05-16-2017, 01:03 PM
 Guloluseus Windows 7 64bit Office 2010 32bit Competent Performer Join Date: Mar 2013 Posts: 132

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
05-16-2017, 11:39 PM
 schmil Windows 10 Office 2016 Novice Join Date: May 2017 Posts: 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"

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post otuatail Excel 10 04-15-2017 05:33 AM CHAVITA Excel 3 01-04-2016 12:57 PM Odyssey Outlook 2 12-07-2014 04:37 PM Brian Reilly Excel 1 01-24-2014 11:56 PM exoson Word 7 01-20-2014 05:09 PM

All times are GMT -7. The time now is 12:30 PM.

 -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top