Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The reason for the title is that I've been looking at all old posts with this
title and not finding the answer I need, I'm sure is simple, but not for me. I have a thousands of dates listed in column A. Those dates could be found several times repeated or just one time, or none. ex: 1/1/8 1/1/8 1/2/8 1/5/8 1/5/8 2/2/8 1/3/9... The formula I'm looking for will count all dates listed as 1/1/8 in any B cell and then the same formula( of course not exactly "same" but alike) will count all dates listed as 1/5/8 in another B cell, and so on. It will be like counting how many sundays, mondays, tuesdays, ... but for reason of space and difficulties of my worksheet I cannot translate this dates to days. Thanks. 1/5/8 1/7/8 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting dates | New Users to Excel | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting dates, within a list of dates | Excel Worksheet Functions | |||
counting dates | Excel Worksheet Functions | |||
Counting Dates | Excel Worksheet Functions |