A | B | C | |
---|---|---|---|
1 | 03/05/2012 | 1 | |
2 | 04/14/2012 | 5 | |
3 | 04/10/2012 | ||
4 | 04/16/2012 | ||
5 | 04/16/2012 | ||
6 | 04/25/2012 | ||
7 | |||
8 | |||
9 | ------------------ | -------- | -------- |
10 |
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
A | B | C | D | |
---|---|---|---|---|
1 | 03/05/2012 | 1 | 1 | |
2 | 04/14/2012 | 5 | 5 | |
3 | 04/10/2012 | |||
4 | 04/16/2012 | |||
5 | 04/16/2012 | |||
6 | 04/25/2012 | |||
7 | ||||
8 | ||||
9 | ------------------ | -------- | ---------- | ---------- |
10 |
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
Try this...Hi guys, I'm using 2003, this will be over a year, it's to collect data for sickness records so in April thirty people could call in sick, May twenty five could call in.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
2 | 1/4/2012 | _ | Jan | 1 | ||
3 | 2/2/2012 | _ | Feb | 1 | ||
4 | 4/24/2012 | _ | Mar | 0 | ||
5 | 5/31/2012 | _ | Apr | 1 | ||
6 | 6/11/2012 | _ | May | 1 | ||
7 | 6/20/2012 | _ | Jun | 3 | ||
8 | 6/25/2012 | _ | Jul | 0 | ||
9 | 8/29/2012 | _ | Aug | 1 | ||
10 | 9/23/2012 | _ | Sep | 1 | ||
11 | 10/5/2012 | _ | Oct | 3 | ||
12 | 10/13/2012 | _ | Nov | 3 | ||
13 | 10/26/2012 | _ | Dec | 4 | ||
14 | 11/23/2012 | _ | _ | _ | ||
15 | 11/23/2012 | _ | _ | _ | ||
16 | 11/26/2012 | _ | _ | _ | ||
17 | 12/1/2012 | _ | _ | _ | ||
18 | 12/8/2012 | _ | _ | _ | ||
19 | 12/21/2012 | _ | _ | _ | ||
20 | 12/25/2012 | _ | _ | _ | ||
Sheet1 |