Points Calendar

[Jeff Bedel]

Okay I got help on duplicating the second calendar below on the attached Attendance spread sheet. The second part I am looking for is the Points need to disappear after 1 year from the date they occurred. So if someone received 3 points on Jan 2, 2016, the points would disappear after Jan 2, 2017. I've tried using the "Today()-365" function. Probably a rookie mistake. Can anyone assist in this?

Thank you!

 

[Jeff Bedel]

I discovered how to do this using the formula :

=SUMIFS(tblLeave[Points],tblLeave[Employee Name],valSelEmployee,tblLeave[Start Date],">="&DATE($AN$5,1,1),tblLeave[End Date],"<"&DATE($AN$5+1,1,1),tblLeave[Points],"<="&TODAY()-365)

Now I'm on to conditional formatting. I need the red numbers to disappear on the "Bottom" calendar after a year from today()'s date.

If anyone has any helpful hints on that, I'm all ears

 

[Jeff Bedel]

Here is the current conditional formatting I'm using:

=(MONTH(H43)=MONTH($C43))*(COUNTIFS(lstEmpNames,valSelEmployee2,lstSdates,"<="&H43,lstEDates,">="&H43,lstPoint4,">0")>0)

I've tried adding ,lstSdates,"<="&today()-365 in several locations but I cannot seem to make it drop any of the dates in red that are past a year from today.