• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

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
0
Karen Schaefer
Asked:
Karen Schaefer
  • 3
  • 2
  • 2
1 Solution
 
barry houdiniCommented:
The syntax should be like this

=NETWORKDAYS(F2,G2)

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

regards, barry
0
 
broro183Commented:
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
 
Karen SchaeferAuthor 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 SchaeferAuthor 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

Featured Post

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.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now