Formula for rolling back three months

I have a spreadsheet I am creating to add attendance "points" for the previous 3 months. Each month of the year has a spearate spreadhsheet tab with the same spreadsheet. What I would like is at the end of each spreadsheet, it would calculate the points in each "point column" for the past three months.

Example: There is a tab for each month on the spreadhseet. (January, February, March, April, etc). On each of these tab pages is a spreadhseet for that month. Columns AP, AR, AT etc are points for that person that day. Column BM I want to say "Total points for last three months." I would like this column to take the current date of whatever date it is when I open the spreadsheet, calculate the points for that month as well as the points for the previous 3 months, going back on the other months tabs.

Can anyone help me with this?

Here is a sample. It starts this month (December 2011). December I would like to show just this month. January the last two months rolling from the current dat. Starting in February and thereafter, The last three months rolling from the current date.

I appreciate it!
Sample attendance tracking 1.xls

Sample attendance tracking 1.xls

ANy ideas?

To be honest, I did not quite understand it. I am relatively new to Excel Programming. Do I go to the VBA editor and just copy and past that formula? How will it tell what the current date is?

I appreciate it!

I appreciate any explanation/help. I am under a kind of time crunch. I reall y do appreciate everyone's help and sorry for my lack of understanding.

As others I have attached a workbook with some data filled in of what I expect it to do. As stated before, I would like it to "roll backward" three months to calculate each person's attendance points. If you look at the page on December 2011, you will see that Jane SMith has .5 points rolling back three months from today's date. (12/14/11). Lance Armstrong has 1.5, again rolling back three months from todays date.

I tried pluggin in the previously suggested formula, but got an error message even though I downloaded the toolpack.

I appreciate any help/advice.
Sample attendance tracking 1.xls

Any advice?

That is a good point. What if there was a separate tab/sheet that indicated everyones name and their point value as of whatever date it is opend?

Well, here is what I was talking about. I added one page that would have everyone's point total three months rolling back from the current date. Disregard the three months rolling column at each month tab, I can change that to just a monthly total. Also, on the added employee point toal page I have a cloumn that would calculate FMLA days rolling back 12 months.

I feel I am almost there. I appreciate greatly the help.

anothersampleattendance.xls

I am getting a #VALUE error.

I downloaded all the toolpaks. I am not sure what you mean on "defining the names" I used CTRL +F3" over "Jane Doe" for example but it did not seem to do anything. I am sure that is not exactly what you meant.

I appreciate your time and help.

error: #VALUE!

I get a "name" error for some reason

I am now getting a run time error. I feel I am so close.

When I enter data on the above spreadsheet, it does not calculate it. The totals on the "Totals" tab just stays the same.

I am also getting a run time error 1004?

I am not sure what is wrong. It is set to automatic. Removed vba codes and re saved. Still not calculating on the "employee points and FMLA totals" tab.

Here is what I have: Sample.xls