Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating weekdays between 2 dates

Status
Not open for further replies.
hamburg18w

hamburg18w

Technical User
Dec 27, 2005
32
US
I run Excel 2003 and would like a formula that tells be how many workdays (Mon-Fri) between two dates. Please help!

Juan
 
Sort by date Sort by votes



Hi,

Check out NETWORKDAYS in analysis toolpack add-in

Skip,
[sup][glasses]Don't let the Diatribe...
talk you to death![tongue][/sup][sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
195
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365 (2016) Working to auto-populate dates 3
Replies
13
Views
269
ladyck3
ladyck3
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
458
combo
combo
RosaseLLEN
  • Locked
  • Question
calculating the distance between cells in excel (randomize moving cells)
Replies
4
Views
171
strongm
strongm
pendle666
  • Locked
  • Question
formula for paydates - calculating maternity pay
Replies
5
Views
103
pendle666
pendle666

Part and Inventory Search

Sponsor

Back
Top