rolling calendar formula

Question

I have a basic calendar set up in excel with the dates (day by day) running across row 1 starting at column c. 

column a is a list of names (although A1 = Today())

every time an employee is absent, a value is assigned to that absence and input into that particular date. 

the formula I'm trying to create would be in column b.  If I were to verbalize the formula it would be like this:  B2= the sum of C2:CFJ2, but only adding the values from the last year, which would be indicated in C1:CFJ1.

in my mind I'm seeing something like A1-365, but I can't visualize the formula.

thanks in advance for any help.

Answer 1

In B2:

=SUMIFS($C2:$CFJ2, $C$1:$C$CFJ1, ">=" & EDATE($A$1,-12), $C$1:$C$CFJ1, "<" & $A$1)

Answer 2

Thanks - I somehow goofed up, I'm glad you managed to make sense of it!

Answer 3

=SUMIFS(C2:CFJ2, $C$1:$CFJ$1, ">=" & EDATE($A$1,-12),$C$1:$CFJ$1, "<" & $A$1)

it had to be slightly modified, but it works!!!  thanks a LOT