# How to calculate number of days between dates

Closed
VickyAliri Posts 1 Registration date Wednesday April 9, 2014 Status Member Last seen April 9, 2014 - Apr 9, 2014 at 07:03 AM
Blocked Profile - Apr 9, 2014 at 04:43 PM
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

Blocked Profile
Apr 9, 2014 at 08:47 AM
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
Blocked Profile
Apr 9, 2014 at 02:22 PM
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
Blocked Profile
Apr 9, 2014 at 04:43 PM
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!