count ifs formula

[SarahMS1]

i did this formula but i dont know why its not working its suppose to count the rows where the status is if done and the date should be from the last 7 days including today can anyone help me

=countifs(table1[status],”done”,table1[date],”<=“&today()-7)
for some reason it counts all the dates

 

[Marcelo Branco]

Maybe...

=COUNTIFS(Table1[Status],"done",Table1[Date],">="&TODAY()-7,Table1[Date],"<="&TODAY())

M.

 

[Marcelo Branco]

If you don't want to count the day =TODAY()-7 (i.e. to count only the last 7 days including today) try
=COUNTIFS(Table1[Status],"done",Table1[Date],">"&TODAY()-7,Table1[Date],"<="&TODAY())

M.

 

[SarahMS1]

Maybe...

=COUNTIFS(Table1[Status],"done",Table1[Date],">="&TODAY()-7,Table1[Date],"<="&TODAY())

M.

yes thank you so much it worked!!!!