# Training Dates - need to analysis them ...

This is a discussion on Training Dates - need to analysis them ... within the Excel Questions forums, part of the Question Forums category; I'm trying to figure out how to get started on code to analysis training dates. We have a large number ...

1. I'm trying to figure out how to get started on code to analysis training dates.

We have a large number of people that have to be trained every year. I trying to find a way to show how many people must be training per month inorder to keep everyone trained without letting anyone go overdue training.

Below are the heading that I am currently using in he file. I don't have any code as of yet ...

```'Persons Name    Office    Training Item    Training Completion Date     Next Due
'Person 1                                   10 Mar 02                    10 Mar 03
'Person 2                                   10 Apr 02                    10 Apr 03
'Person 3                                   01 Jan 02                    01 Jan 03
'Person 4                                   10 Jun 02                    10 Jun 03```

[ This Message was edited by: em on 2002-10-19 06:41 ]

2. Hello em

Care to post a spreadheet sample and your expected out come (most important)would be helpful. I see from your other posts that you have already been introduced to the Colo utility....it would sure help me better understand your requirement.

pll

3. number of people needed to be trained per month = number of people / 12 !

On the assumption that this isn't the correct answer, care to elaborate on the extra parameters we need to consider...

edit: plettieri - "snap"

[ This Message was edited by: PaddyD on 2002-10-19 08:25 ]

4. I wiil try to a spreadsheet example using colos--standby ...

5. I think I was putting to much thought into the project this morning, and think I have it figured out now, but would like a couple of things ...

1. What formula would return "5 months and 10 days" in one cell and "5 months / 160 days" in another cell.

Those two questions apply to cell C10 and 11 on the spreadsheet shown here.

******** ******************** ************************************************************************>
 Microsoft Excel - 916 ARW DTTM1.xls ___Running: xl2000 : OS = Windows NT 4
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 C2D2C3D3C4D4C5D5C6D6C7D7C8C12D12 =

A
B
C
D
2
*Total*People*in*Organization*=1010
3
4
*Total*People*Within*90*of*OverDue*=24
5
*Total*People*Overdue*Right*Now*=4*
6
*Total*People*Awaiting*Initial*Training*(AIT)*=22
7
*Total*Peop*with*No*Training*Date*=11
8
*Today*=19-Oct-02*
9
*Inspectors*Arrive*On:1-Apr-031-May-03
10
*Months*and*Days*Till*Inspectors*Arrive*=month*and*daysmonths*and*day
11
*Months*/*Days*Till*Inspectors*Arrive*=month*/*daysmonths*/*days
12
13
**Trn*Item*1Trn*Item*2
14
NameOffice1.**Date*Traing*Occurred
2.**Training*Interval*24*months
1.**Date*Traing*Occurred
2.**Training*Interval*12*Months
15
Person*1*01*Jan*0201*Mar*02
16
Person*2*12*Jan*9901*Mar*02
17
Person*3*12*Jan*9901*Mar*02
18
Person*4*AITAIT
19
Person*5*AITAIT
20
Person*6*12*Jan*9912*Jan*02
21
Person*7*12*Jan*9912*Jan*02
22
Person*8*12*Jan*0112*Jan*02
23
Person*9*12*Jan*0112*Jan*02
24
Person*10***
 916 AGS - DTM (2) *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[ This Message was edited by: em on 2002-10-19 12:21 ]

6. Try =DATE.DIFF(c8,c9,2)..for your first question ...this is an add on function found in http://longre.free.fr/english/

a similar function or a variation of the first may fit your needs on the second question. I am looking at that now

pll

[ This Message was edited by: plettieri on 2002-10-19 13:06 ]

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•