Results 1 to 16 of 16

Calculate difference between dates excluding weekends

Threaded View

nitinjoshi123 Calculate difference between... 05-22-2008, 10:33 PM
EdMac try this - it does not matter... 05-23-2008, 04:37 AM
oldchippy If you haven't got the... 05-23-2008, 05:05 AM
daddylonglegs Is it possible for the start... 05-23-2008, 07:27 AM
nitinjoshi123 Hi Yes!!! the start date can... 05-25-2008, 05:11 PM
nitinjoshi123 USING NETWORKDAYS if the... 05-26-2008, 07:22 AM
oldchippy Hi, If the start date... 05-26-2008, 07:51 AM
EdMac This gives the answers you... 05-26-2008, 10:59 AM
nitinjoshi123 Hi OldChippy If the start... 05-26-2008, 06:46 PM
nitinjoshi123 HI Edmac Itried this but it... 05-26-2008, 07:29 PM
  1. #1
    Registered User
    Join Date
    05-22-2008
    Posts
    19

    Calculate difference between dates excluding weekends

    Hi there
    I would like to know how i can calculate the difference (in days) between two dates, excluding the weekends from the calculation.
    For example lets say A1 has 22 May 2008 and A2 has 27 May 2008. How do i calculate the difference between A2 and A1 so i get the answer as 3. Using Networkdates gives me 4 (it includes the start date in the calculation). I can't use datedif because sometimes my first date is smaller than the second date, in which case it gives me an error.
    Also, occasionally my two dates are from two different years like it can be 22 May 2007 and 27 May 2008.
    It would be really helpful if someone can help with this.
    Many Thanks in advance
    Cheers
    Nitin
    Last edited by nitinjoshi123; 05-23-2008 at 12:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1