Counting number of dates
Closed
april
-
Dec 4, 2009 at 03:40 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 6, 2009 at 09:09 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 6, 2009 at 09:09 PM
Related:
- Counting number of dates
- Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
- Defcon dates - Guide
- Stop counting days in excel when status is changed ✓ - Excel Forum
- Using nested if to blank out adjacent cells - Excel Forum
- How to highlight overdue dates in excel ✓ - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 4, 2009 at 09:32 PM
Dec 4, 2009 at 09:32 PM
Post a small examply. the column entries may be divided by a slash so that the entreis are clear.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 6, 2009 at 09:09 PM
Dec 6, 2009 at 09:09 PM
your data is like this
in column c (leave column B blank) type like this
now in D2 copy this formula
now copy D2 to D3 and D4
the result in column D wil be
if there are more rows modify column C and the formula in D2 and copy down
if there are more rows and dates modify correspondingly
POST CONFIRMATION WHETHER IT IS OK
date 2/3/2009 3/3/2009 4/2/2009 4/3/2009 4/5/2009
in column c (leave column B blank) type like this
MONTH 2 3 4
now in D2 copy this formula
==COUNT(IF(MONTH($A$2:$A$6)=C2,$A$2:$A$6))
invoke this formula with CONTRL+SHIFT+ENTER
now copy D2 to D3 and D4
the result in column D wil be
number 1 1 3
if there are more rows modify column C and the formula in D2 and copy down
if there are more rows and dates modify correspondingly
POST CONFIRMATION WHETHER IT IS OK
Dec 6, 2009 at 11:09 AM
2/3/2009
3/3/2009
4/2/2009
4/3/2009
4/5/2009
=COUNTIF(A1:A12,">=4/1/2009, <=4/30/2009")
This is the formula that I tried and got 0 entries. Formated column to date and changed the cell that I put the formula in to general format.
I don't know if I should us another formula or function, any suggestions?