Date Difference between 2 dates - Displaying total days minus Weekends

I have a spreadsheet where I need to determine Actual days minus weekends - I tried using Networkdays without success.


=NETWORKDAYS(F2-G2)  I turned on the Analysis Pack tool addin still without luck

any ideas why this is not working - If I was doing it in Access I would use DateDif function.

Karen NetworkDays
Karen SchaeferBI ANALYSTAsked:
Who is Participating?
 
broro183Connect With a Mentor Commented:
hi,

I think Barry has got it sussed for you but here are some techniques you can use in the future to help you quickly learn the syntax of functions within excel...

- click in the formula bar somewhere between the brackets of a function & then click the [fx] button just to the left of the formula bar, this brings up a dialogbox which provides brief explanations as you click through each of the fields.

- make the [F1] key your friend, push it & search the Help files using the function name as a keyword in your search.

re networkdays, if you are also interested in other time/date related functions you may find Chip's pages useful: http://www.cpearson.com/excel/datetimews.htm
http://www.cpearson.com/excel/datetime.htm

hth
Rob
0
 
barry houdiniCommented:
The syntax should be like this

=NETWORKDAYS(F2,G2)

it includes both start and end date.....

regards, barry
0
 
Karen SchaeferBI ANALYSTAuthor Commented:
thanks for the suggestion - I added two more columns to the spreadsheet to hold the Data conversion forumla then used those fields to calc the NetworkDays function.

K
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
broro183Commented:
hi K,

Thanks for the points, but I don't deserve them. It was Barry who answered the question.

Rob
__________________
Rob Brockett. Always learning & the best way to learn is to experience...
0
 
Karen SchaeferBI ANALYSTAuthor Commented:
I disagree, It was your links that gave me the answer, I already had the correct forumla, it was the conversion  of the DateSerial to date Date(F2), M... that gave me the solutions.  However, If you wish to share the points let me know and I will contact the administrator.

k
0
 
barry houdiniCommented:
Hello Karen, Rob

In fact the formula you showed in your question and in the screenshot wasn't correct - you have =NETWORKDAYS(F2-G2) when it should be =NETWORKDAYS(F2,G2).......but I guess that was just a typo. If you feel Rob supplied the information you needed to solve the issue then I have no problem with the points allocation as it stands.

regards, barry
0
 
broro183Commented:
hi Karen & Barry,

Okay, if everyone else is happy then I'm happy too :-)

It was the typo & wording of the question that made me think the points should be for Barry. My links were only ever intended as a "hey, by the way, you can check this out for other useful tips & tricks", but I'm pleased they helped (sooner than I expected).

Barry, thanks for your generousity, it is one small step on the journey from "new kid on the block" to one of you guys with a ranking by my name - thankyou :-)

Rob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.