A Microsoft Excel recall spread sheet using calendar dates.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rockconner07 - 11 Sep 2007 04:32 GMT

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: rockconner07@comcast.net I
have to go online (so to speak) in two weeks. Please some help me. Thanks,
Rock

Reply to this Message

Marutiram - 11 Sep 2007 12:26 GMT

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

> HI All,
> I have to make a spread sheet using Microsoft Excel. I have to be able to
[quoted text clipped - 3 lines]
> have to go online (so to speak) in two weeks. Please some help me. Thanks,
> Rock

Reply to this Message

Bernard Liengme - 11 Sep 2007 12:36 GMT

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

Signature

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

Reply to this Message

rockconner07 - 12 Sep 2007 02:32 GMT

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

> In A1 type the text "Last Name" - no quotes
> In B1 enter the text "First Name"
[quoted text clipped - 20 lines]
> > have to go online (so to speak) in two weeks. Please some help me. Thanks,
> > Rock

Reply to this Message

Bernard Liengme - 12 Sep 2007 14:40 GMT

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

Signature

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

> 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
[quoted text clipped - 34 lines]
>> > Thanks,
>> > Rock

Reply to this Message