Hello,
I have 2 date fields:
Column I8: 10/10
Column I9: 10/17
In Column I10, I want to subtract the difference in dates (I9 - I8), including only Business Days, and return a value of 5.
How do I go about doing that?
Hello,
I have 2 date fields:
Column I8: 10/10
Column I9: 10/17
In Column I10, I want to subtract the difference in dates (I9 - I8), including only Business Days, and return a value of 5.
How do I go about doing that?
The function is NETWORKDAYS.
=NETWORKDAYS(I8, I9)
The answer is actually 6, there are 6 working days in that range. If you don't want the result to be inclusive, put a -1 at the end.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You could try networkdays =NETWORKDAYS(I8,I9) though that will return 6 instead of 5 as 10/10/2016 is a Monday and so is 10/17/2016 so it will count Monday-Friday as 5 and the add'l Monday as the 6th day.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks