Search : in
By :

Count Days Excluding Weekends

Last answer on Oct 12, 2009 1:20:41 pm BST Negra781, on Oct 9, 2009 4:42:09 pm BST 
 Report this message to moderators

Hello,

I want to do a monthly report and I have four colums: "issue date" "pick date" "pack date" "Ship date", each cell have dates, I need a formula that helps me calculate the dates since issue date that took to be pick, pack and ship. but I need to exclude the weekends for the calculation of dates. Please help!!!!!

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Count Days Excluding Weekends » in :
How to count number of words in MS Words sheet! ShowHow to count number of words in MS Words sheet! It is quite simple to count the number of words in a Microsoft word sheet. This tip might be very useful for example, if you wish to make a presentation on Microsoft word for an approximate...
Mktime() - Timestamp yesterday, last month, etc.). ShowMktime() - Timestamp yesterday, last month, etc.) Intro Last 24 hours Yesterday This week Last week This Month Last 30 days (last 30 days) Last month Current year(this year) Last year (last year) Intro The mktime()function...
Counting the number of words in a document (Word or OpenOffice) ShowCounting the number of words in a document (Word or OpenOffice.org) Microsoft Word OpenOffice.org It is sometimes useful to count the number of words or characters in a document. The two major office suites can do it very...
Download Equinoxes, Solstices and Cross-Quarter Days ShowDescription The application is designed by Hermetic Systems. This is a tool that allows you to calculate accurate date and time for equinoxes, solstices and cross-quarter days. Simple and easy to use, the application has been awarded from various...
Download Rapid PDF Count ShowRapid PDF allows you to know the number of pages in your PDF document and to generate reports with some clicks. This program has been designed to count the words and number of pages, to measure the file size, to load or add lists, etc…It has...
Download Rapid TIFF Page Count Show
Binary encoding ShowIntroduction to binary In the late 1930s, Claude Shannon showed that by using switches which were closed for "true" and open for "false," it was possible to carry out logical operations by assigning the number 1 to "true" and 0 for "false." This...
Connecting the computer to a HIFI sound system ShowWhy connect a computer to a sound system? These days, computers provide sound quality that is as good as hifi sound systems. It is possible to use them to listen to music, in particular thanks to mp3 files that provide sound quality that is...
Mini-DIN connector Show4-pin Mini-DIN connector The 4-pin Mini-DIN connector is used for transmitting analog video in S-Video format: More and more graphics cards these days have an S-Video socket built in, so that the computer's output can be viewed on a television...
Ask your question Reply

1

sharpman, on Oct 10, 2009 3:23:28 pm BST

I think you will find what you are looking for on this link
http://www.mrexcel.com/archive/Dates/16735.html

hope it helps

   
Reply to sharpman

2

 Trowa, on Oct 12, 2009 1:20:41 pm BST

Hi Negra,

There is a function named NETWORKDAYS which will calculate the days between two dates excluding the weekends.

Best regards,
Trowa

   
Reply to Trowa
Ask your question Reply
They need your help