|
|
wbmkk
regular
Reg'd: Tue
Posts: 191
Loc: Whitley Bay, UK
|
|
Hi
Does anybody know a way of counting days using EXCEL
We need it to be able to determine how old a job is, but this must not include weekends, so if for example
job 1 raised on 14th may today it'll be into day 6
but
job 2 raised on 9th may, today only into day 3
thanks !
|
|
putasolutions
regular
Reg'd: Tue
Posts: 12322
Loc: Infinity and beyond
|
|
Yes quite simple using the networkdays function, see this page on how to use it
NOTE: If the NetworkDays formula results in a NAME? error message, you need to install the Analysis Toolpak Add In.
From the Excel menu, click Tools | AddIns. Select the Analyis Toolpak and click OK.
Reenter your formula.
--------------------
"Only the stupid don't ask questions."
My piccies
|
Marcus
regular
Reg'd: Tue
Posts: 264
|
|
Iain
Thank you for mentioning that tip, I have a use for that function as well.
Thanks
Marcus
|
putasolutions
regular
Reg'd: Tue
Posts: 12322
Loc: Infinity and beyond
|
|
If you have a holiday period in the workday period, you need to have a fourth column, so you have a start date cell, end date cell, and a bank holiday cell(s)
so your formula becomes
=networkdays(start date cell,end date cell,bank holiday cells)
|
Marcus
regular
Reg'd: Tue
Posts: 264
|
|
Oh yes and I will be using that as well. 
Thanks
Marcus
|
Previous
Index
Next
Threaded
Edit
Reply
Quote
