Share via

Rolling 365 day tracking

Anonymous
2022-06-06T18:49:52+00:00

I have an attendance tracker that I am using to track the number of absences in a rolling year. I have a formula but it is still coming up with one too many absences included. What am I doing wrong?

Formula in W4:

=COUNTIFS($C$4:$V$4,">="&TODAY()-365)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
  1. Anonymous
    2022-06-06T19:21:50+00:00

    Make sure your dates are true dates - try changing the format to Number - if the display doesn't change to a number like 44339 then you have strings, not dates.

    1 person found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Anonymous
    2022-06-06T19:33:46+00:00

    Thanks - that was it.

    Greatly appreciate your help!

    0 comments No comments
  2. Anonymous
    2022-06-06T19:15:07+00:00

    Hi Bernie,

    Thanks so much for the help.

    I'm still coming up with 7 has the count - it should be six: 5/31/21 should no longer count so left with

    8/2/2021 10/24/2021 2/15/2022 5/4/2022 5/18/2022 6/5/2022

    any idea why?

    0 comments No comments
  3. Anonymous
    2022-06-06T19:01:55+00:00

    =COUNTIFS($C$4:$V$4,">="&EDATE(TODAY(),-12)+1)

    0 comments No comments