count number sunday+saturday in many week

C

chu

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

Anne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

week numbers 3
Get Number of Date between two date but not include Saturday/Sunday 1
Friday & Saturday 3
Working days between 2 dates 3
Week Numbers - Again! 4
Count items based on two criteria 7
Using weekdays only in a schedule 4
Identifying Weekdays 16

Top