COUNTIF the date in one column is within the last 7 days of a date in another cell

    I'm stumped on this one.


    This is what I need:
    If the dates in I7:I106 are equal to "week ending date" (which will be changed every week in cell L3) or within the last 7 days of "week ending date", then COUNT cells J7:J106 if they equal the word "Deficient"


    Any takers?

    Re: COUNTIF the date in one column is within the last 7 days of a date in another cel


    A small example will be nice to prepare the formulas.
    You want to count how many times L3 is included in the range I7:I106 then check if column J for the same rows is equal to Deficient

    Triumph without peril brings no glory: Just try

    Re: COUNTIF the date in one column is within the last 7 days of a date in another cel


    Try using COUNTIFS, i.e.


    =COUNTIFS(I7:I106,">"&L3-7,I7:I106,"<="&L3,J7:J106,"Deficient")

    Re: COUNTIF the date in one column is within the last 7 days of a date in another cel


    I just get an error when I try that. "The formula you typed contains an error"

    Re: COUNTIF the date in one column is within the last 7 days of a date in another cel


    Did ever try to cange , to ;

    Triumph without peril brings no glory: Just try

Participate now!

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

Register Yourself Login