A1 is the return cell. In my spreadsheet the columns D, G, J, M, P, S, V, Z,
AC etc contain the numbers of days absent in Apr09, May09, Jun09, Jul09,
Aug09, Sept09, Oct09, Nov09, Dec09, Jan, Feb, Mar, Apr, etc. for my employees.

I need to report the absence of the employee over the last six months, in
other words How many days absence did the employee have form Apr09. Next
month I need to have a return of absence from May09. In December I need the
last six months from Jun09. Its a rolling six months.



"Jacob Skaria" wrote:

You havent mentioned how your data is arraned...Explain a bit about that if
possible post sample data/

If this post helps click Yes
---------------
Jacob Skaria


"JohnPM" wrote:

The return in cell A1 should read the sum of six different cells. These cells
will be identified by a time period over the last six months from today
now()
What strategy (or formula) should I use to make this happen?

What I am looking at is to count the number of days absent in the last six
months of an employee, recorded in separate months.