How-to Articles

• Technology Repair Requests

• Calculating the Number of Days Between Two Dates

• Viewing Attachments in Outlook

• Quick and Easy Photo Displays

Technology Repair Requests
By Sue Sledge

When you find yourself in need of equipment repair you should first contact your site Technology Specialist for assistance.  If your site does not have a specialist, direct your request to ITRepair@amphi.com.  Please include your site, room number, type of equipment, ASD tag number and serial number (if possible).  If your request is of an urgent nature or you do not have e-mail access, please direct your call to me at X5214.  Requests to ITRepair may also include network issues, installations and phone repairs.  A repair ticket will be generated and your request will be handled in the order in which it was received. 

Calculating the Number of Days Between Two Dates
By Sheri Sense

Have you ever needed to calculate the number of days between two different dates?  Excel is powerful and has a feature that makes it incredibly easy to get this number.  All you do is the following few steps:

1. Just enter your two dates that you need into two different cells.

2. Click on the cell to contain your answer.  You will need to format the cell to “number” with no decimals.

3. Type the equal sign, then click on the end date, type the minus key, then click on the start date.

4. Press “enter.”

5. Viola!  You have the number of days between the two dates.

For the advanced users J, you can even ask it for the “Net Workdays!”  This calculates only the workdays, not the weekends or holidays.  It returns the number of whole working days between start date and end date. Working days exclude weekends and any dates identified as holidays by the user.  Example: NETWORKDAYS can be used to calculate employee benefits that accrue based on the number of days worked during a specific term.

To do this, you will do the following few steps:

1. Enter the two dates that you need analyzed.

2. Click in the cell to contain your answer.

3. Click on the function key (fx) just above your spreadsheet.

4. Scroll down to NETWORKDAYS* and click OK.

5. Click on the Start Date, End Date and put in the number of days that are holidays.  Click OK.

*Just in case your NETWORKDAYS is not an option in your function keys, here’s what to do:

1. In the Tools menu, click Add-Ins.

2. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

3. Now when you click on your function (fx) key, it will be an option.