A Microsoft Excel recall spread sheet using calendar dates.

[Guest]

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: (e-mail address removed) I
have to go online (so to speak) in two weeks. Please some help me. Thanks,
Rock

 

[Guest]

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

 

[Bernard Liengme]

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

 

[Guest]

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]

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