MarkDShark
Board Regular
- Joined
- Jun 10, 2008
- Messages
- 228
I need a formula that can list dates in order on another sheet as I enter them on the entry sheet. Im trying to create a spreadsheet that tracks payment dates plus the amount as it subtracts out the balance. Sort of like the example below. I have the first part deducting as I input, but what I want to do, is to be able to enter all the dates no matter what order they are in, but as I do, I need the 2nd spreadsheet to put them in order in a certain format, example below of the entry form, of coarse it should have the lines etc.
Date of loan: 04-15-2010 End Date: 04-15-2015
Balance $4,100.00 ($150.60)
No DATE AMOUNT
1 7/17/2013 $376.65
2 8/21/2013 $376.65
3 9/18/2013 $376.65
4 4/15/2013 $1,949.00
5 11/20/2013 $376.65
6 12/18/2013 $409.65
7 2/19/2014 $385.35
I would need the next sheet to put them in order from earliest to the latest as well as the corresponding payment starting with the "Date of loan" date and ending with the "End Date". So in this example, No4 should show first on the next sheet as I type in the dates at random on the input sheet. Outcome should be in following format below,
04152010 04152013 4,100.00 <-- (Starting with the Date of loan, then the April payment date then the balance)
04152013 07172013 2,151.00 <-- (Carrying down April date, subtracting April payment $ entered on the input sheet, reflecting new balance)
07172013 08212013 1,774.35 <-- (Carrying down next date completing process till all payments entered
08212013 09182013 1,397.70
09182013 11202013 1,021.05
11202013 12182013 644.40
12182013 02192014 234.75
02192014 04152015 -150.60 <-- (Last payment date as well as the "End date". Balance was paid 02192014.
The format is sort of in a zig zag order but needs to be for the sheet im trying to create. Hope you understand it.
Date of loan: 04-15-2010 End Date: 04-15-2015
Balance $4,100.00 ($150.60)
No DATE AMOUNT
1 7/17/2013 $376.65
2 8/21/2013 $376.65
3 9/18/2013 $376.65
4 4/15/2013 $1,949.00
5 11/20/2013 $376.65
6 12/18/2013 $409.65
7 2/19/2014 $385.35
I would need the next sheet to put them in order from earliest to the latest as well as the corresponding payment starting with the "Date of loan" date and ending with the "End Date". So in this example, No4 should show first on the next sheet as I type in the dates at random on the input sheet. Outcome should be in following format below,
04152010 04152013 4,100.00 <-- (Starting with the Date of loan, then the April payment date then the balance)
04152013 07172013 2,151.00 <-- (Carrying down April date, subtracting April payment $ entered on the input sheet, reflecting new balance)
07172013 08212013 1,774.35 <-- (Carrying down next date completing process till all payments entered
08212013 09182013 1,397.70
09182013 11202013 1,021.05
11202013 12182013 644.40
12182013 02192014 234.75
02192014 04152015 -150.60 <-- (Last payment date as well as the "End date". Balance was paid 02192014.
The format is sort of in a zig zag order but needs to be for the sheet im trying to create. Hope you understand it.