How to calculate number of days between dates [Closed]

Report
Posts
1
Registration date
Wednesday April 9, 2014
Status
Member
Last seen
April 9, 2014
-
 Blocked Profile -
Please I need ideas of how to get the number of days between to sets of dates in an excel column. The preceeding dates all the way to the end of the last row in the column.

4 replies


Vicky,

Have you even attempted this in excel? =a1-b1.

Assumes A1 is a date greater than B1. Is this for real? Am I being Punked?


"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
yes, I've already done that. The challenge is that I want to calculate for subsequent rows as shown below:

Date (A) DT_DIFF (B)
1/4/2007 0
1/4/2007 8
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007

This is just a subset of the file as the data spans up to 50000 records and so I cannot manually compute =A3-A2, =A4-A3 etc manually.
Please I need help with the formular to use to base my calculated on.

Thank you

Golly, you are right. How could I have ever confused the first scope of work as stated: "Please I need ideas of how to get the number of days between to sets of dates in an excel column. The preceeding dates all the way to the end of the last row in the column."; with the actual scope of work as revised?

"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon

It sounds to me, like you are asking for a MACRO. If a formula cannot be dragged into place, then you need VBA.

YOur structure explaination is rather incomplete, also. I am failing to see any resemblence of a question or explaination to what you are asking, as you have now just changed the scope of the question, but still not completely formulated an example of final product.

Have FUN!