Roll back three months

**stryped** · 01-11-2012, 10:44 AM

Thanks to everyone on here, I am almost done with my spreadsheet to calculate attendance. I am the one that needed to cauculate points by rolling back three months from the current date. I also needed to track FMLA by rolling back 12 months.

I plugged everything in but on the final page that is supposed to have every employees total "rolling back three months", it calculates too much. Example as of today it should go back three months. (October 11, 2011 - January 11, 2012.). But it is adding points that occured before 10/11/11.

I appreciate any help in fixing this formula. I think this is the last piece of the puzzle.

I am trying ot attach it but it says the file of 2 mb is too big????????

**stryped** · 01-11-2012, 11:18 AM

final test.zip

Here. Will this work:

**stryped** · 01-11-2012, 05:21 PM

Any ideas as to what is wrong?

**Haseeb A** · 01-11-2012, 05:44 PM

If you want to include current month with previous 3 months, change these named ranges.

Last3Months on refers to;

=TEXT(DATE(YEAR(CurrDate),MONTH(CurrDate)-{3,2,1,0},1),"mmmm yyyy")

SumColumn

=DAY(DATE(YEAR(CurrDate),MONTH(CurrDate)-{2,1,0,-1},0))*3+3

Delete the names & recreate with the new formulas. ALWAYS KEEP A Back up of your file.

**stryped** · 01-12-2012, 09:28 AM

Where do I put these? What I want is the final total page to count the number of points going back a rolling three months to the day. Example: If today is January 11, 2012 it should count any points accured from 10/11/11 to 1/11/12.

**Haseeb A** · 01-13-2012, 12:58 PM

Press Ctrl+F3, select name Last3Months & click Delete. Then click Add, enter name as Last3Months on refers to enter,

=TEXT(DATE(YEAR(CurrDate),MONTH(CurrDate)-{3,2,1,0},1),"mmmm yyyy")

Click OK

Select SumColumn & click Delete, then click Add enter name as SumColumn, on refers to,

=DAY(DATE(YEAR(CurrDate),MONTH(CurrDate)-{2,1,0,-1},0))*3+3

Click OK

See the attached.