count number sunday+saturday in many week

's Computer Specifications

I don't know what function can count number sunday+saturday in range of
weeks. Please help me. Thanks

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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