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

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

Post by S2hhb » Tue, 19 Sep 2006 02:47:01



 
 
 

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

Post by Debra Dalg » Tue, 19 Sep 2006 03:44:05

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
here:

http://www.yqcomputer.com/




--
Debra Dalgleish
Contextures
http://www.yqcomputer.com/

 
 
 

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

Post by Biff » Tue, 19 Sep 2006 03:57:53

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, where:

Sunday = 1 through Saturday = 7

Biff