PC Review


Reply
Thread Tools Rate Thread

count number sunday+saturday in many week

 
 
chu
Guest
Posts: n/a
 
      1st Jul 2003
I don't know what function can count number sunday+saturday in range of
weeks. Please help me. Thanks

 
Reply With Quote
 
 
 
 
Anne
Guest
Posts: n/a
 
      1st Jul 2003
Use the function Weekday(A1) to give the day of the week (Sunday=1,
Saterday=7)
If you haven't this function you have to activate the Add-Inn Analysis
Toolpak as follows:
Tools - Add-Inns - Analysis Toolpak

To calculate the number of Sundays and Saterday:
=CountIf(Range,1) + CountIf(Range,7)

Anne


"chu" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I don't know what function can count number sunday+saturday in range of
> weeks. Please help me. Thanks
>



 
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
Group Week Sunday to Saturday CJ Microsoft Access Reports 5 8th Apr 2008 10:02 PM
find dates for sunday and saturday of last week =?Utf-8?B?QmFycnk=?= Microsoft Access Queries 1 27th Jun 2006 06:40 PM
changing the work week to Sunday through Saturday =?Utf-8?B?amRhdmlz?= Microsoft Outlook Discussion 1 29th Nov 2005 05:20 PM
Change format so Sunday is first day of week and Saturday the last =?Utf-8?B?U3RldmU=?= Microsoft Outlook Calendar 2 30th Mar 2005 10:59 PM
printing Sunday to Saturday work week MonyaG Microsoft Outlook Calendar 1 8th Sep 2004 05:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:30 PM.