LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Really counting DATES

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting dates M Kan New Users to Excel 3 July 30th 08 02:31 PM
counting occasions dates occur between 2 dates hoyt New Users to Excel 5 June 16th 06 08:11 AM
Counting dates, within a list of dates jrheinschm Excel Worksheet Functions 7 April 19th 06 06:13 PM
counting dates dayzee Excel Worksheet Functions 1 February 15th 06 10:20 AM
Counting Dates Jerry Excel Worksheet Functions 1 March 8th 05 02:01 PM


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"