| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif date
I have a single column a2:a30 that is formatted for dates. I would
appreciate any help in getting the right forumula to count the number of January entries. Thank you very much in advance. 04-Jan-06 05-Jan-06 12-Jan-06 01-Feb-06 04-Feb-06 13-Mar-06 15-Mar-06 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif date
=countif(a2:a30,"="&date(2006,1,1))-countif(a2:a30,"="&date(2006,2,1))
That's counting the number of entries in or after January, then subtracting the number in or after February, leaving only January entries. --Bruce "ferde" wrote: I have a single column a2:a30 that is formatted for dates. I would appreciate any help in getting the right forumula to count the number of January entries. Thank you very much in advance. 04-Jan-06 05-Jan-06 12-Jan-06 01-Feb-06 04-Feb-06 13-Mar-06 15-Mar-06 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif date
AWESOME it works great. Thank you so much for your speedy reply
"bpeltzer" wrote: =countif(a2:a30,"="&date(2006,1,1))-countif(a2:a30,"="&date(2006,2,1)) That's counting the number of entries in or after January, then subtracting the number in or after February, leaving only January entries. --Bruce "ferde" wrote: I have a single column a2:a30 that is formatted for dates. I would appreciate any help in getting the right forumula to count the number of January entries. Thank you very much in advance. 04-Jan-06 05-Jan-06 12-Jan-06 01-Feb-06 04-Feb-06 13-Mar-06 15-Mar-06 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Date Math Problem | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
Linear Mode
