PC Review


Reply
Thread Tools Rate Thread

Days between 2 dates excluding Sundays only

 
 
JGGL
Guest
Posts: n/a
 
      30th Sep 2011
Hi, I need to get the number of days between 2 dates excluding Sundays
only. I know about networkdays but that exclude all weekend and take
in consideration all week days as 1 day.
Example 1
A2 = Sep 16 (Fri)
B2 = Sep 19 (Mon)
If you do B2-A2 = 3 because Fri = 0 Sat = 1 Sun = 1 and Mon = 1
Using NETWORKDAYS(A2,B2) = 2 because Friday = 1 and Monday = 1
What I need is B2-A2 = 2 Fri = 0 Sat = 0 Sun = 1 and Mon = 1
Result 2

Example 2
A2 = Sep 15 (Thu)
B2 = Sep 16 (Fri)
If you do B2-A2 = 1 because Thu = 0 Fri = 1
Using NETWORKDAYS(A2,B2) = 2 because Thu = 1 and Fri = 1
What I need is B2-A2 = 1 Thu = 0 Fri = 1

Are you able to help me?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting # of days between 2 dates excluding Fri & Sat) Khaledity Microsoft Excel Worksheet Functions 31 29th Mar 2009 01:05 PM
Calculating Networking days excluding Sundays Bahboosh Microsoft Excel Discussion 6 12th Sep 2008 11:18 AM
Working Days excluding Sundays =?Utf-8?B?ZGFuaA==?= Microsoft Excel Misc 6 31st Mar 2007 08:52 PM
Excel - list days of a month, excluding Sundays =?Utf-8?B?Sm9obg==?= Microsoft Excel Misc 1 3rd Jan 2006 04:43 PM
Count Days excluding Sundays KENNY Microsoft Excel Worksheet Functions 3 11th Nov 2004 05:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:56 AM.