Counting Date Occurances
How do I get Excel to take a column of dates and
automatically count how many times a date is repeated. I want to use it to auto populate answers in a worksheet to show how many jobs are booked for each day of the week. Jerry |
Hi!
Try this: =COUNTIF(A1:A100,"1/1/2005") or =COUNTIF(A1:A100,DATE(2005,1,1)) Biff -----Original Message----- How do I get Excel to take a column of dates and automatically count how many times a date is repeated. I want to use it to auto populate answers in a worksheet to show how many jobs are booked for each day of the week. Jerry . |
All times are GMT +1. The time now is 03:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com