PDA

View Full Version : Dates and Days



Lina
06-25-2011, 07:46 AM
Good Afternoon

I hope and pray that this mail finds you well.

Please may I ask your assistance in the following.

I have a spreadsheet that contains the following data:

1. start date
2. end date
3. status

The start date refers to the date a request was created. The end date refers to the date the request was closed. The status refers to well basically the status of the request (1 = closed, 2 = inactive, 3 = open, 4 = rejected, 5 = cancelled).

I would like to do the follow:

1. Calculate the days from the start to end dates.
2. Plot the day on a graph (basically we would like to work out how long it really takes to handle a request from start to end).
3. It should also reflect the current open requests and reflect how long it has been opened.
4. Further I would like to calculate the total number items against each status.

Now I have to admit that I am not very good at Excel but would really like to try and get this information if possible in an excel graph.

I am very open to any suggestions/recommendations you may have on how to depict this information.

Your help is greatly appreciated.

Thank you

Lina

Bob Phillips
06-25-2011, 10:42 AM
Do open status have an end date or is that still blank?

Can you post an example workbook?

Lina
06-25-2011, 11:15 AM
Hi

Thank you for your reply.

Please find attached a copy of the spreadsheet.

Thank you for your help.

Lina

Bob Phillips
06-25-2011, 05:18 PM
Is this the sort of thing you want?

Lina
06-26-2011, 08:29 AM
Wow that is awesome.

I will go through it in more detail and give you feedback.

Thank you so much.

Lina
:)