| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
New Member
Join Date: Apr 2011
Posts: 3
|
I Have an attendance tracker i am trying to set up a column that counts how many "s" (for sick day) are in a row for the last 30 days of the day you open the file so i will have a running total of sick days for the past 30 days at any given point in time so far i have something like this but it is not working please help
 =COUNTIFs(E5:NE5,"s"(e4:NE4,today()-30)) E4 to NE4 is the dates 1/1/11 - 12/31/11 E5 to NE5 are the empty cell you can type S in for sick day |
|
|
|
|||
|
|
| |
|
New Member
Join Date: Apr 2011
Posts: 3
|
 Somebody anybody please
|
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| employee attendance tracker | Ross | Microsoft Excel Misc | 0 | 24th May 2010 09:19 AM |
| 2009 Attendance Tracker available to download yet? | Gloria in Hawaii | Microsoft Word Document Management | 1 | 5th Dec 2008 06:44 PM |
| Building an Attendance Tracker | Jeremy | Microsoft Excel Misc | 6 | 27th Oct 2008 10:12 PM |
| attendance tracker | =?Utf-8?B?amVubnlu?= | Microsoft Excel Misc | 2 | 11th Jan 2006 07:08 PM |
| Excel as Attendance Tracker | Donna123 | Microsoft Excel Misc | 8 | 26th Dec 2005 07:39 PM |
