how to find nos. of each day in certain nos. of days?
 

how to find nos. of each day in certain nos. of days?
 

If you provide more information about your data, someone may be able to
provide advice.

However, if you have a list of days, you could create a pivot table from
the list, to get a count of each day. There are instructions and links
he

http://www.contextures.com/xlPivot01.html


Khan wrote:

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

how to find nos. of each day in certain nos. of days?
 

To count the number of Mondays between 2 dates (inclusive):

A1 = start date
A2 = end date

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=2))

2 = day of the week = Monday, whe

Sunday = 1 through Saturday = 7

Biff

"Khan" wrote in message
...