HI All,
I have to make a spread sheet using Microsoft Excel. I have to be able to
tell drivers when there DOD cards are due for renewal and their driver
license also. What is the best way. I'm talking about 3500 drivers. Your
help would be greatly appreciated. My email is: I
have to go online (so to speak) in two weeks. Please some help me. Thanks,
Rock

Please try the date function. It should help you keep track of the renewal
dates.


"rockconner07" wrote:

HI All,
I have to make a spread sheet using Microsoft Excel. I have to be able to
tell drivers when there DOD cards are due for renewal and their driver
license also. What is the best way. I'm talking about 3500 drivers. Your
help would be greatly appreciated. My email is: I
have to go online (so to speak) in two weeks. Please some help me. Thanks,
Rock

In A1 type the text "Last Name" - no quotes
In B1 enter the text "First Name"
In C1 enter: "DOD"
In D1 "Licence"

Now start to enter all you data, it does not matter what order you process
the drivers.
In column A: enter driver's last name
In B; enter drivers first name(s)
In C; the DOD date in whatever format you prefer such as 10/12/07
In D: the license renewal date

Select everything and use Data | Sort; sort by Last Name and First Name

When you have all this come back with detailed questions of what you want to
do.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"rockconner07" wrote in message
...
HI All,
I have to make a spread sheet using Microsoft Excel. I have to be able to
tell drivers when there DOD cards are due for renewal and their driver
license also. What is the best way. I'm talking about 3500 drivers. Your
help would be greatly appreciated. My email is: I
have to go online (so to speak) in two weeks. Please some help me. Thanks,
Rock

Thanks for your help. Okay I made a small spread sheet. What is the next
step to have it tell me which driver license/DOD card is due. I have use the
Microsoft Excel for some time now. I have made many different spread sheets.
I just haven't learned how to make one to tell me how to do this kind of
calculation yet. Thanks, Rock


"Bernard Liengme" wrote:

In A1 type the text "Last Name" - no quotes
In B1 enter the text "First Name"
In C1 enter: "DOD"
In D1 "Licence"

Now start to enter all you data, it does not matter what order you process
the drivers.
In column A: enter driver's last name
In B; enter drivers first name(s)
In C; the DOD date in whatever format you prefer such as 10/12/07
In D: the license renewal date

Select everything and use Data | Sort; sort by Last Name and First Name

When you have all this come back with detailed questions of what you want to
do.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"rockconner07" wrote in message
...
HI All,
I have to make a spread sheet using Microsoft Excel. I have to be able to
tell drivers when there DOD cards are due for renewal and their driver
license also. What is the best way. I'm talking about 3500 drivers. Your
help would be greatly appreciated. My email is: I
have to go online (so to speak) in two weeks. Please some help me. Thanks,
Rock

Suppose the first due date is in C2
I will assume you want to know expired licences and those due within 10 days
Here are a couple or ways:

1) In D2 enter =IF(C2-TODAY()<10, "Licence due","")
Copy this down the column; quickest way is to double click the fill handle
(small solid square in lower right corner of active call)

OR
2) Select all dates in C column
Use Format | Conditional Formatting
In the dialog use
Formula Is; =C2-TODAY()<10; and click Format button; open Pattern tab and
click a colour. Now the cell with a due date less than 10 days from today
will show with a colour. For more about conditional formatting see:
http://www.contextures.com/xlCondFormat01.html

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"rockconner07" wrote in message
...
Thanks for your help. Okay I made a small spread sheet. What is the next
step to have it tell me which driver license/DOD card is due. I have use
the
Microsoft Excel for some time now. I have made many different spread
sheets.
I just haven't learned how to make one to tell me how to do this kind of
calculation yet. Thanks, Rock


"Bernard Liengme" wrote:

In A1 type the text "Last Name" - no quotes
In B1 enter the text "First Name"
In C1 enter: "DOD"
In D1 "Licence"

Now start to enter all you data, it does not matter what order you
process
the drivers.
In column A: enter driver's last name
In B; enter drivers first name(s)
In C; the DOD date in whatever format you prefer such as 10/12/07
In D: the license renewal date

Select everything and use Data | Sort; sort by Last Name and First Name

When you have all this come back with detailed questions of what you want
to
do.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"rockconner07" wrote in message
...
HI All,
I have to make a spread sheet using Microsoft Excel. I have to be able
to
tell drivers when there DOD cards are due for renewal and their driver
license also. What is the best way. I'm talking about 3500 drivers.
Your
help would be greatly appreciated. My email is:
I
have to go online (so to speak) in two weeks. Please some help me.
Thanks,
Rock