Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
Hi John,
Please add some sample data to your request, we need a view on this to help you further. Wkr, JP "JohnPM" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
On Sun, 18 Oct 2009 07:45:01 -0700, 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. Take a look at this annual log, and change, use, delete, or whatever as you wish. It is a trusted Microsoft User submitted template. http://office.microsoft.com/en-us/te...070531033.aspx There is another that has it by weeks: http://office.microsoft.com/en-us/te...067601033.aspx It has some flaws tho that I recently discovered and am working on, but is worth a look for conceptual aid anyway. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
Thank you, just a small problem, I use the Excel 2003 version.
"WallyWallWhackr" wrote: On Sun, 18 Oct 2009 07:45:01 -0700, 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. Take a look at this annual log, and change, use, delete, or whatever as you wish. It is a trusted Microsoft User submitted template. http://office.microsoft.com/en-us/te...070531033.aspx There is another that has it by weeks: http://office.microsoft.com/en-us/te...067601033.aspx It has some flaws tho that I recently discovered and am working on, but is worth a look for conceptual aid anyway. . |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
Thank you, this looks halpful, but I now need to dig my heels into pivot
tables. "Herbert Seidenberg" wrote: Excel 2007 PivotTable Last 6 months. http://www.mediafire.com/file/zzqjky3dl03/10_18_09.xlsx . |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding employee absence history
Start date 01/08/2009
A B C D E F G H J K 1 last 6 aug09 sep09 oct09 nov09 dec09 jan10 feb10 mar10 2 employee 01 ?? 2 5 1 0 0 3 4 3 Today the return in B2 should be 7 (Aug09+Sep09) in Nov09 the return in B2 should be 8 (Aug09+Sep09+Oct09) in Dec09 the return in B2 should be 8 (Aug09+Sep09+Oct09+Nov09) in Jan10 the return in B2 should be 8 (Aug09+Sep09+Oct09+Nov09+Dec09) in Feb10 the return in B2 should be 11 (Aug09+Sep09+Oct09+Nov09+Dec09+Jan09) in Mar10 the return in B2 should be 13 (Sep09+Oct09+Nov09+Dec09+Jan09+Feb09) in Apr10 the return in B2 should be 11 (Oct09+Nov09+Dec09+Jan09+Feb09+Mar09) And so on; rolling six month period... "JP Ronse" wrote: Hi John, Please add some sample data to your request, we need a view on this to help you further. Wkr, JP "JohnPM" wrote in message ... 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I update the Employee Absence Schedule template to 2009? | Setting up and Configuration of Excel | |||
Employee Absence Schedule for 2007? | Excel Discussion (Misc queries) | |||
change the year in employee absence schedule | Excel Worksheet Functions | |||
Employee Absence Schedule Template | Excel Discussion (Misc queries) | |||
Change the Employee Absence schedule template to 2006? | Excel Worksheet Functions |