How to countifs dates between todays date and 7 days ago

  • Hi, I need a formula to calculate the number of documents issued between todays date and 7 days ago.


    I tried =COUNTIFS(B2:B39,">="&TODAY()-7,B2:B39,"<="&TODAY()) but it doesn't work and just gives value zero.


    Help appreciated :thanx:


    Basic table looks like:


    [TABLE="class: grid, width: 500, align: left"]

    [tr]


    [td]

    DOCUMENT NO

    [/td]


    [td]

    DATE ISSUE

    [/td]


    [/tr]


    [tr]


    [td]

    3001-XXXX-XXX-XXX

    [/td]


    [td]

    29/11/2015

    [/td]


    [/tr]


    [tr]


    [td]

    3002-XXXX-XXX-XXX

    [/td]


    [td]

    27/11/2015

    [/td]


    [/tr]


    [tr]


    [td]

    3003-XXXX-XXX-XXX

    [/td]


    [td]

    10/10/2015

    [/td]


    [/tr]


    [tr]


    [td]

    3004-XXXX-XXX-XXX

    [/td]


    [td]

    09/09/2015

    [/td]


    [/tr]


    [/TABLE]

  • Re: How to countifs dates between todays date and 7 days ago


    Nothing wrong with the formula, maybe your formulas calculation setting set to manual, try change to "automatic"


    Steps
    1. Click on "Formulas" tab
    2. Click "Calculation Options"
    3. And choose "Automatic"

  • Re: How to countifs dates between todays date and 7 days ago


    Hi azumi


    Thank you for your reply. Automatic was ticked.


    Still got me why it not working.


    :thanx:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!