Forum Discussion

John Duff's avatar
John Duff
Copper Contributor
Jun 06, 2018
Solved

Frequency function for counting dates

Hi, I have a column that contains date values rounded with the INT function.  My understanding is that these can be counted using the Frequency function but I am not getting the result I expect.   ...
Excel Desktop
Formulas & Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jun 06, 2018

    John,

     

    =IF(COUNTIFS(A$1:A1,A1)=1,COUNTIFS($A$1:$A$10,A1),0)

     

    Or with FREQUENCY(): Select B1:B10, type in the formula and press CTRL-SHIFT-ENTER.

    {=FREQUENCY($A$1:$A$10,$A$1:$A$10)}

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 06, 2018

John,

 

=IF(COUNTIFS(A$1:A1,A1)=1,COUNTIFS($A$1:$A$10,A1),0)

 

Or with FREQUENCY(): Select B1:B10, type in the formula and press CTRL-SHIFT-ENTER.

{=FREQUENCY($A$1:$A$10,$A$1:$A$10)}

 

JNollett's avatar
JNollett
Copper Contributor
Sep 10, 2019

Hi Detlef_Lewin 

 

I have looked at this contribution to see if would assist me, but it doesn't quite achieve what I would like to do.

 

I though I had done what I need to when I got the answer "8" (Cell D6 on the Output tab) in the attached file for working days, but realised I hadn't when I reduced the time between the dates. The formula is picking up the unique dates, but not between the specified dates. Can you see what I have done wrong with FREQUENCY please?

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Sep 10, 2019

    JNollett 

    First, please always start a new conversation. Do not hijack threads started by other users.

    Second, the formula in D6 is an array formula. You have to enter it with CTRL-SHIFT-ENTER instead of just ENTER.

     

Resources