How many Saturday and Sundays ?

[makinmomb]

Assume cell a1 has a date e.g. 01/08/2014
Assume cell a1 has a date e.g. 31/12/2014

What is the formula on a3 to find out how many
weekends are there i.e. saturday and sunday ?

[nathansav]

=WEEKNUM(b1)-WEEKNUM(a1)

[:) Sixthsense :)]

=INT(A2-A1-NETWORKDAYS(A1,A2))

Used Int() to set the cell formatting to general instead of changing as date.

[AlKey]

or this

=ABS(NETWORKDAYS(A1,A2)-(A2-A1))

Format cell as General

[Tony Valko]

If you're using Excel 2010 or later:

A1 = start date
B1 = end date

To count how many Saturdays and Sundays within the date range (inclusive):

=NETWORKDAYS.INTL(A1,B1,"1111100")

[makinmomb]

Thanks i took that of nathansav , shorter

Sixthsense I will collection yours too , glad
to tell you I am still using you branch stocking
formula till date

You had corrected it if you recall for the prior
formula that had too many loops into one formula

[Tony Valko]

Apparently I misunderstood the question.

[makinmomb]

Though I should start a next thread for this ,
but it would be too short ,

Also looking for how many Fridays between
two range of dates

[Tony Valko]

Also looking for how many Fridays between
two range of dates

Try one of these...

In Excel 2010 or later:

A1 = start date
B1 = end date

=NETWORKDAYS.INTL(A1,B1,"1111011")

This one will work in every version of Excel:

=INT((WEEKDAY(A1-5,2)+B1-A1)/7)