How do i draw out Saturday and Sunday when using time diff

**zalora** · 03-28-2013, 04:46 AM

For example the start date is 21 march (thursday) to 28 march (next thursday). The normal time diff is 7 day . but what I want is the diff is 5 days Saturday and Sunday no included for calculated

**cytop** · 03-28-2013, 05:19 AM

Use the WORKDAY() function in the Analysis Tool pack (http://www.cpearson.com/excel/ATP.htm)

**buran** · 03-28-2013, 05:19 AM

Hi
no need of vba for this - you can use networkdays formula.
Or if it is in the code, use WorksheetFunction.networkdays

Buran

**Pepe Le Mokko** · 03-28-2013, 05:27 AM

@cytop the WORKDAYS and NETWORKDAYS ( what OP needs) function are native to XL2010

**zalora** · 03-28-2013, 05:32 AM

Thank helping me, i just found and create my own code. Although my code is seem noob. But here is the code

Please Login or Register  to view this content.

How do i draw out Saturday and Sunday when using time diff

LinkBack

Thread Tools

Rate This Thread

Display

How do i draw out Saturday and Sunday when using time diff

Re: How do i draw out Saturday and Sunday when using time diff

Re: How do i draw out Saturday and Sunday when using time diff

Re: How do i draw out Saturday and Sunday when using time diff

Re: How do i draw out Saturday and Sunday when using time diff

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions