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
Blocked Profile - Apr 9, 2014 at 04:43 PM
Related:
- How to calculate number of days between dates
- Skype last seen days ago - Guide
- How to calculate position in excel - Excel Forum
- How to calculate vat in excel - Guide
- How to calculate fuel surcharge - Excel Forum
- How to calculate percentage of marks of 6 subjects - Excel Forum
4 responses
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
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
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
"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!
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!
