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

D

Debra Dalgleish

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.contextures.com/xlPivot01.html


Khan wrote:
 
B

Biff

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
 
Top