Need Formula for Monthly Calculation

N

NonStopLeo

New Member
Joined
Mar 25, 2010
Messages
38
Dear Friends

I need a formula to amortize my expenses in below sheet. I want in Column L monthly amortization on the basis, if full month is used then it should calculate for 30 days, if not full month then calculate based on day used in that month.
Days in year base should be 30 days. Kindly help.

[TABLE="width: 1226"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 2"]COMPANY NAME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]INSURANCE AMORTIZATION[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Opening[/TD]
[TD][/TD]
[TD][/TD]
[TD] Closing [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01-Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[TD]28-Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Cost[/TD]
[TD="colspan: 2"]Opening[/TD]
[TD="colspan: 2"] Closing [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S.No[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Ref No[/TD]
[TD]Description[/TD]
[TD]No of Days[/TD]
[TD]AMOUNT[/TD]
[TD]No of Days[/TD]
[TD] Amortization [/TD]
[TD]No of Days[/TD]
[TD] Amortization [/TD]
[TD] Charge for the Month [/TD]
[TD] Prepaid Balance [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1-Oct-17[/TD]
[TD]31-Dec-17[/TD]
[TD]BPV-8417[/TD]
[TD]ADCO Fujairah[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]11-Oct-17[/TD]
[TD]7-Feb-18[/TD]
[TD]BPV-8489[/TD]
[TD]Mirfa Land - Bouroge[/TD]
[TD] 116.00[/TD]
[TD] 5,530.00[/TD]
[TD] 110.00[/TD]
[TD] 5,243.97[/TD]
[TD] 116.00[/TD]
[TD] 5,530.00[/TD]
[TD] 286.03[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6-Feb-17[/TD]
[TD]5-Feb-18[/TD]
[TD]6677[/TD]
[TD]01/4102/41/2017/50[/TD]
[TD] 359.00[/TD]
[TD] 2,712.00[/TD]
[TD] 355.00[/TD]
[TD] 2,681.78[/TD]
[TD] 359.00[/TD]
[TD] 2,712.00[/TD]
[TD] 30.22[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]15763[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 357.00[/TD]
[TD] 2,220.00[/TD]
[TD] 330.00[/TD]
[TD] 2,052.10[/TD]
[TD] 357.00[/TD]
[TD] 2,220.00[/TD]
[TD] 167.90[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]15-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]14988[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 343.00[/TD]
[TD] 3,232.00[/TD]
[TD] 316.00[/TD]
[TD] 2,977.59[/TD]
[TD] 343.00[/TD]
[TD] 3,232.00[/TD]
[TD] 254.41[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1-Apr-17[/TD]
[TD]31-Mar-18[/TD]
[TD]W/C[/TD]
[TD]01/1151/11/2016/38[/TD]
[TD] 360.00[/TD]
[TD] 4,588.00[/TD]
[TD] 300.00[/TD]
[TD] 3,823.33[/TD]
[TD] 330.00[/TD]
[TD] 4,205.67[/TD]
[TD] 382.33[/TD]
[TD] 382.33[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]11-Jul-17[/TD]
[TD]28-Feb-18[/TD]
[TD]78427[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 227.00[/TD]
[TD] 1,681.13[/TD]
[TD] 200.00[/TD]
[TD] 1,481.17[/TD]
[TD] 227.00[/TD]
[TD] 1,681.13[/TD]
[TD] 199.96[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]20-Jul-17[/TD]
[TD]15-Jan-18[/TD]
[TD]99609[/TD]
[TD]01/4102/41/2017/251[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]28-Jul-17[/TD]
[TD]25-Jan-18[/TD]
[TD]56570[/TD]
[TD]01/4102/41/2017/259[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]7-Aug-17[/TD]
[TD]30-Jul-18[/TD]
[TD]70691[/TD]
[TD]01/4102/41/2017/263[/TD]
[TD] 353.00[/TD]
[TD] 2,182.00[/TD]
[TD] 174.00[/TD]
[TD] 1,075.55[/TD]
[TD] 204.00[/TD]
[TD] 1,260.99[/TD]
[TD] 185.44[/TD]
[TD] 921.01[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]17-Aug-17[/TD]
[TD]16-Aug-18[/TD]
[TD]93187[/TD]
[TD]01/4102/41/2017/268[/TD]
[TD] 359.00[/TD]
[TD] 2,500.00[/TD]
[TD] 164.00[/TD]
[TD] 1,142.06[/TD]
[TD] 194.00[/TD]
[TD] 1,350.97[/TD]
[TD] 208.91[/TD]
[TD] 1,149.03[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]27-Aug-17[/TD]
[TD]26-Aug-18[/TD]
[TD]87816[/TD]
[TD]01/4102/41/2017/287[/TD]
[TD] 359.00[/TD]
[TD] 6,050.00[/TD]
[TD] 154.00[/TD]
[TD] 2,595.26[/TD]
[TD] 184.00[/TD]
[TD] 3,100.84[/TD]
[TD] 505.57[/TD]
[TD] 2,949.16[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]25-Sep-17[/TD]
[TD]28-Feb-18[/TD]
[TD]85151[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 153.00[/TD]
[TD] 2,293.00[/TD]
[TD] 126.00[/TD]
[TD] 1,888.35[/TD]
[TD] 153.00[/TD]
[TD] 2,293.00[/TD]
[TD] 404.65[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]23-Aug-17[/TD]
[TD]15-Feb-18[/TD]
[TD]68521[/TD]
[TD]01/4102/41/2017/274[/TD]
[TD] 172.00[/TD]
[TD] 1,300.00[/TD]
[TD] 158.00[/TD]
[TD] 1,194.19[/TD]
[TD] 172.00[/TD]
[TD] 1,300.00[/TD]
[TD] 105.81[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]10-Sep-17[/TD]
[TD]9-Sep-18[/TD]
[TD]16999[/TD]
[TD]01/4102/41/2017/303[/TD]
[TD] 359.00[/TD]
[TD] 2,345.00[/TD]
[TD] 141.00[/TD]
[TD] 921.02[/TD]
[TD] 171.00[/TD]
[TD] 1,116.98[/TD]
[TD] 195.96[/TD]
[TD] 1,228.02[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]18-Sep-17[/TD]
[TD]28-Feb-18[/TD]
[TD]99717[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 160.00[/TD]
[TD] 1,065.00[/TD]
[TD] 133.00[/TD]
[TD] 885.28[/TD]
[TD] 160.00[/TD]
[TD] 1,065.00[/TD]
[TD] 179.72[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]30-Oct-17[/TD]
[TD]30-Apr-18[/TD]
[TD]54234[/TD]
[TD]05/4102/41/2017/191[/TD]
[TD] 180.00[/TD]
[TD] 2,470.00[/TD]
[TD] 91.00[/TD]
[TD] 1,248.72[/TD]
[TD] 121.00[/TD]
[TD] 1,660.39[/TD]
[TD] 411.67[/TD]
[TD] 809.61[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]26-Oct-17[/TD]
[TD]20-Apr-18[/TD]
[TD]68137[/TD]
[TD]05/4102/41/2017/189[/TD]
[TD] 174.00[/TD]
[TD] 2,308.00[/TD]
[TD] 95.00[/TD]
[TD] 1,260.11[/TD]
[TD] 125.00[/TD]
[TD] 1,658.05[/TD]
[TD] 397.93[/TD]
[TD] 649.95[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]26-Oct-17[/TD]
[TD]15-Oct-18[/TD]
[TD]98959[/TD]
[TD]05/4102/41/2017/175[/TD]
[TD] 349.00[/TD]
[TD] 1,728.00[/TD]
[TD] 95.00[/TD]
[TD] 470.37[/TD]
[TD] 125.00[/TD]
[TD] 618.91[/TD]
[TD] 148.54[/TD]
[TD] 1,109.09[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]2-Nov-17[/TD]
[TD]30-Apr-18[/TD]
[TD]75941[/TD]
[TD]05/4102/41/2017/193[/TD]
[TD] 178.00[/TD]
[TD] 1,922.00[/TD]
[TD] 89.00[/TD]
[TD] 961.00[/TD]
[TD] 118.00[/TD]
[TD] 1,274.13[/TD]
[TD] 313.13[/TD]
[TD] 647.87[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]10-Nov-17[/TD]
[TD]5-May-18[/TD]
[TD]53892[/TD]
[TD]05/4102/41/2017/197[/TD]
[TD] 175.00[/TD]
[TD] 2,416.00[/TD]
[TD] 81.00[/TD]
[TD] 1,118.26[/TD]
[TD] 110.00[/TD]
[TD] 1,518.63[/TD]
[TD] 400.37[/TD]
[TD] 897.37[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]9-Nov-17[/TD]
[TD]8-Dec-18[/TD]
[TD]96115[/TD]
[TD]05/4102/41/2017/198[/TD]
[TD] 389.00[/TD]
[TD] 1,790.00[/TD]
[TD] 82.00[/TD]
[TD] 377.33[/TD]
[TD] 111.00[/TD]
[TD] 510.77[/TD]
[TD] 133.44[/TD]
[TD] 1,279.23[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]29-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]67183[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 89.00[/TD]
[TD] 559.00[/TD]
[TD] 62.00[/TD]
[TD] 389.42[/TD]
[TD] 89.00[/TD]
[TD] 559.00[/TD]
[TD] 169.58[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]29-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]16574[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 89.00[/TD]
[TD] 560.00[/TD]
[TD] 62.00[/TD]
[TD] 390.11[/TD]
[TD] 89.00[/TD]
[TD] 560.00[/TD]
[TD] 169.89[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]6-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]97201[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 82.00[/TD]
[TD] 517.00[/TD]
[TD] 55.00[/TD]
[TD] 346.77[/TD]
[TD] 82.00[/TD]
[TD] 517.00[/TD]
[TD] 170.23[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]27-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]64160[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 91.00[/TD]
[TD] 1,366.00[/TD]
[TD] 64.00[/TD]
[TD] 960.70[/TD]
[TD] 91.00[/TD]
[TD] 1,366.00[/TD]
[TD] 405.30[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]11-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]26890[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 77.00[/TD]
[TD] 511.00[/TD]
[TD] 50.00[/TD]
[TD] 331.82[/TD]
[TD] 77.00[/TD]
[TD] 511.00[/TD]
[TD] 179.18[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]13-Dec-17[/TD]
[TD]12-Dec-18[/TD]
[TD]85170[/TD]
[TD]05/4102/41/2017/218[/TD]
[TD] 359.00[/TD]
[TD] 3,202.00[/TD]
[TD] 48.00[/TD]
[TD] 428.12[/TD]
[TD] 77.00[/TD]
[TD] 686.78[/TD]
[TD] 258.66[/TD]
[TD] 2,515.22[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]28-Dec-17[/TD]
[TD]27-Dec-18[/TD]
[TD]65705[/TD]
[TD]05/4102/41/2017/237[/TD]
[TD] 359.00[/TD]
[TD] 4,410.00[/TD]
[TD] 33.00[/TD]
[TD] 405.38[/TD]
[TD] 62.00[/TD]
[TD] 761.62[/TD]
[TD] 356.24[/TD]
[TD] 3,648.38[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]21-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]74061[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 67.00[/TD]
[TD] 292.00[/TD]
[TD] 40.00[/TD]
[TD] 174.33[/TD]
[TD] 67.00[/TD]
[TD] 292.00[/TD]
[TD] 117.67[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]TOTAL[/TD]
[TD] [/TD]
[TD] 69,702.13[/TD]
[TD] [/TD]
[TD] 44,777.09[/TD]
[TD] [/TD]
[TD] 51,515.85[/TD]
[TD] 6,738.75[/TD]
[TD] 18,186.28[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
I can replicate almost all these numbers using the formulae:

F9: =DAYS360(B9,C9)
H9: =DAYS360(B9,MIN(C9,H$4))
J9: =DAYS360(B9,MIN(C9,1+K$4))
L9: =ROUND((J9-H9)/F9*G9,2)

However, there are five rows with a one day discrepancy. For example, for S.No = 21, cell J2 shows 118 days, whereas I have 119. This may be an error. Or it may be due to the particular version of the 360 day calendar you're using. Excel uses US/NASD. Do you know what you're using?
 
Upvote 0
StephenCrump said:
I can replicate almost all these numbers using the formulae:

F9: =DAYS360(B9,C9)
H9: =DAYS360(B9,MIN(C9,H$4))
J9: =DAYS360(B9,MIN(C9,1+K$4))
L9: =ROUND((J9-H9)/F9*G9,2)

However, there are five rows with a one day discrepancy. For example, for S.No = 21, cell J2 shows 118 days, whereas I have 119. This may be an error. Or it may be due to the particular version of the 360 day calendar you're using. Excel uses US/NASD. Do you know what you're using?
Click to expand...

Thanks for your Reply, However it is not giving the desired results.

Column H & J shouldn’t be Negative
Column F & J should be 360 if Start & End Dates are Full Year, Currently it is giving different, i.e 357,359,360
Charge For the Month should be Equal to 30 Days if Full Month is Used, Currently it is coming 27 in Case of February i.e S.No 6 & 8
I am Using US NASD Method i.e FALSE

[TABLE="width: 1500"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD="colspan: 2"]COMPANY NAME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]INSURANCE AMORTIZATION[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Opening[/TD]
[TD][/TD]
[TD][/TD]
[TD] Closing [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01-Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[TD]28-Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Cost[/TD]
[TD="colspan: 2"]Opening[/TD]
[TD="colspan: 2"] Closing [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S.No[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Ref No[/TD]
[TD]Description[/TD]
[TD]No of Days[/TD]
[TD]AMOUNT[/TD]
[TD]No of Days[/TD]
[TD] Amortization [/TD]
[TD]No of Days[/TD]
[TD] Amortization [/TD]
[TD] Charge for the Month [/TD]
[TD] Prepaid Balance [/TD]
[TD]REMARKS[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1-Oct-17[/TD]
[TD]31-Dec-17[/TD]
[TD]BPV-8417[/TD]
[TD]ADCO Fujairah[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]11-Oct-17[/TD]
[TD]7-Feb-18[/TD]
[TD]BPV-8489[/TD]
[TD]Mirfa Land - Bouroge[/TD]
[TD] 116.00[/TD]
[TD] 5,530.00[/TD]
[TD] 110.00[/TD]
[TD] 5,243.97[/TD]
[TD] 116.00[/TD]
[TD] 5,530.00[/TD]
[TD] 286.03[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6-Feb-17[/TD]
[TD]5-Feb-18[/TD]
[TD]6677[/TD]
[TD]01/4102/41/2017/50[/TD]
[TD] 359.00[/TD]
[TD] 2,712.00[/TD]
[TD] 355.00[/TD]
[TD] 2,681.78[/TD]
[TD] 359.00[/TD]
[TD] 2,712.00[/TD]
[TD] 30.22[/TD]
[TD] - [/TD]
[TD] Column F & J should be 360 [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]15763[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 357.00[/TD]
[TD] 2,220.00[/TD]
[TD] 330.00[/TD]
[TD] 2,052.10[/TD]
[TD] 357.00[/TD]
[TD] 2,220.00[/TD]
[TD] 167.90[/TD]
[TD] - [/TD]
[TD] Column F & J should be 360 [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]15-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]14988[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 343.00[/TD]
[TD] 3,232.00[/TD]
[TD] 316.00[/TD]
[TD] 2,977.59[/TD]
[TD] 343.00[/TD]
[TD] 3,232.00[/TD]
[TD] 254.41[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1-Apr-17[/TD]
[TD]31-Mar-18[/TD]
[TD]W/C[/TD]
[TD]01/1151/11/2016/38[/TD]
[TD] 360.00[/TD]
[TD] 4,588.00[/TD]
[TD] 300.00[/TD]
[TD] 3,823.33[/TD]
[TD] 330.00[/TD]
[TD] 4,205.67[/TD]
[TD] 382.33[/TD]
[TD] 382.33[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]78427[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 357.00[/TD]
[TD] 1,681.13[/TD]
[TD] 330.00[/TD]
[TD] 1,553.99[/TD]
[TD] 357.00[/TD]
[TD] 1,681.13[/TD]
[TD] 127.14[/TD]
[TD] - [/TD]
[TD] Column F & J should be 360 [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]20-Jul-17[/TD]
[TD]15-Jan-18[/TD]
[TD]99609[/TD]
[TD]01/4102/41/2017/251[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]28-Jul-17[/TD]
[TD]25-Jan-18[/TD]
[TD]56570[/TD]
[TD]01/4102/41/2017/259[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]7-Aug-17[/TD]
[TD]30-Jul-18[/TD]
[TD]70691[/TD]
[TD]01/4102/41/2017/263[/TD]
[TD] 353.00[/TD]
[TD] 2,182.00[/TD]
[TD] 174.00[/TD]
[TD] 1,075.55[/TD]
[TD] 204.00[/TD]
[TD] 1,260.99[/TD]
[TD] 185.44[/TD]
[TD] 921.01[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]17-Aug-17[/TD]
[TD]16-Aug-18[/TD]
[TD]93187[/TD]
[TD]01/4102/41/2017/268[/TD]
[TD] 359.00[/TD]
[TD] 2,500.00[/TD]
[TD] 164.00[/TD]
[TD] 1,142.06[/TD]
[TD] 194.00[/TD]
[TD] 1,350.97[/TD]
[TD] 208.91[/TD]
[TD] 1,149.03[/TD]
[TD] Column F should be 360 [/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]27-Aug-17[/TD]
[TD]26-Aug-18[/TD]
[TD]87816[/TD]
[TD]01/4102/41/2017/287[/TD]
[TD] 359.00[/TD]
[TD] 6,050.00[/TD]
[TD] 154.00[/TD]
[TD] 2,595.26[/TD]
[TD] 184.00[/TD]
[TD] 3,100.84[/TD]
[TD] 505.57[/TD]
[TD] 2,949.16[/TD]
[TD] Column F should be 360 [/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]25-Sep-17[/TD]
[TD]28-Feb-18[/TD]
[TD]85151[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 153.00[/TD]
[TD] 2,293.00[/TD]
[TD] 126.00[/TD]
[TD] 1,888.35[/TD]
[TD] 153.00[/TD]
[TD] 2,293.00[/TD]
[TD] 404.65[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]23-Aug-17[/TD]
[TD]15-Feb-18[/TD]
[TD]68521[/TD]
[TD]01/4102/41/2017/274[/TD]
[TD] 172.00[/TD]
[TD] 1,300.00[/TD]
[TD] 158.00[/TD]
[TD] 1,194.19[/TD]
[TD] 172.00[/TD]
[TD] 1,300.00[/TD]
[TD] 105.81[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]10-Sep-17[/TD]
[TD]9-Sep-18[/TD]
[TD]16999[/TD]
[TD]01/4102/41/2017/303[/TD]
[TD] 359.00[/TD]
[TD] 2,345.00[/TD]
[TD] 141.00[/TD]
[TD] 921.02[/TD]
[TD] 171.00[/TD]
[TD] 1,116.98[/TD]
[TD] 195.96[/TD]
[TD] 1,228.02[/TD]
[TD] Column F should be 360 [/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]18-Sep-17[/TD]
[TD]28-Feb-18[/TD]
[TD]99717[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 160.00[/TD]
[TD] 1,065.00[/TD]
[TD] 133.00[/TD]
[TD] 885.28[/TD]
[TD] 160.00[/TD]
[TD] 1,065.00[/TD]
[TD] 179.72[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]30-Oct-17[/TD]
[TD]30-Apr-18[/TD]
[TD]54234[/TD]
[TD]05/4102/41/2017/191[/TD]
[TD] 180.00[/TD]
[TD] 2,470.00[/TD]
[TD] 91.00[/TD]
[TD] 1,248.72[/TD]
[TD] 121.00[/TD]
[TD] 1,660.39[/TD]
[TD] 411.67[/TD]
[TD] 809.61[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]26-Oct-17[/TD]
[TD]20-Apr-18[/TD]
[TD]68137[/TD]
[TD]05/4102/41/2017/189[/TD]
[TD] 174.00[/TD]
[TD] 2,308.00[/TD]
[TD] 95.00[/TD]
[TD] 1,260.11[/TD]
[TD] 125.00[/TD]
[TD] 1,658.05[/TD]
[TD] 397.93[/TD]
[TD] 649.95[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]26-Oct-17[/TD]
[TD]15-Oct-18[/TD]
[TD]98959[/TD]
[TD]05/4102/41/2017/175[/TD]
[TD] 349.00[/TD]
[TD] 1,728.00[/TD]
[TD] 95.00[/TD]
[TD] 470.37[/TD]
[TD] 125.00[/TD]
[TD] 618.91[/TD]
[TD] 148.54[/TD]
[TD] 1,109.09[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]2-Nov-17[/TD]
[TD]30-Apr-18[/TD]
[TD]75941[/TD]
[TD]05/4102/41/2017/193[/TD]
[TD] 178.00[/TD]
[TD] 1,922.00[/TD]
[TD] 89.00[/TD]
[TD] 961.00[/TD]
[TD] 119.00[/TD]
[TD] 1,284.93[/TD]
[TD] 323.93[/TD]
[TD] 637.07[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]10-Nov-17[/TD]
[TD]5-May-18[/TD]
[TD]53892[/TD]
[TD]05/4102/41/2017/197[/TD]
[TD] 175.00[/TD]
[TD] 2,416.00[/TD]
[TD] 81.00[/TD]
[TD] 1,118.26[/TD]
[TD] 111.00[/TD]
[TD] 1,532.43[/TD]
[TD] 414.17[/TD]
[TD] 883.57[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]9-Nov-17[/TD]
[TD]8-Nov-18[/TD]
[TD]96115[/TD]
[TD]05/4102/41/2017/198[/TD]
[TD] 359.00[/TD]
[TD] 1,790.00[/TD]
[TD] 82.00[/TD]
[TD] 408.86[/TD]
[TD] 112.00[/TD]
[TD] 558.44[/TD]
[TD] 149.58[/TD]
[TD] 1,231.56[/TD]
[TD] Column F should be 360 [/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]29-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]67183[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 89.00[/TD]
[TD] 559.00[/TD]
[TD] 62.00[/TD]
[TD] 389.42[/TD]
[TD] 89.00[/TD]
[TD] 559.00[/TD]
[TD] 169.58[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]29-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]16574[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 89.00[/TD]
[TD] 560.00[/TD]
[TD] 62.00[/TD]
[TD] 390.11[/TD]
[TD] 89.00[/TD]
[TD] 560.00[/TD]
[TD] 169.89[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]6-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]97201[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 82.00[/TD]
[TD] 517.00[/TD]
[TD] 55.00[/TD]
[TD] 346.77[/TD]
[TD] 82.00[/TD]
[TD] 517.00[/TD]
[TD] 170.23[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]27-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]64160[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 91.00[/TD]
[TD] 1,366.00[/TD]
[TD] 64.00[/TD]
[TD] 960.70[/TD]
[TD] 91.00[/TD]
[TD] 1,366.00[/TD]
[TD] 405.30[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]11-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]26890[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 77.00[/TD]
[TD] 511.00[/TD]
[TD] 50.00[/TD]
[TD] 331.82[/TD]
[TD] 77.00[/TD]
[TD] 511.00[/TD]
[TD] 179.18[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]13-Dec-17[/TD]
[TD]12-Dec-18[/TD]
[TD]85170[/TD]
[TD]05/4102/41/2017/218[/TD]
[TD] 359.00[/TD]
[TD] 3,202.00[/TD]
[TD] 48.00[/TD]
[TD] 428.12[/TD]
[TD] 78.00[/TD]
[TD] 695.70[/TD]
[TD] 267.58[/TD]
[TD] 2,506.30[/TD]
[TD] Column F should be 360 [/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]28-Dec-17[/TD]
[TD]27-Dec-18[/TD]
[TD]65705[/TD]
[TD]05/4102/41/2017/237[/TD]
[TD] 359.00[/TD]
[TD] 4,410.00[/TD]
[TD] 33.00[/TD]
[TD] 405.38[/TD]
[TD] 63.00[/TD]
[TD] 773.90[/TD]
[TD] 368.52[/TD]
[TD] 3,636.10[/TD]
[TD] Column F should be 360 [/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]21-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]74061[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 67.00[/TD]
[TD] 292.00[/TD]
[TD] 40.00[/TD]
[TD] 174.33[/TD]
[TD] 67.00[/TD]
[TD] 292.00[/TD]
[TD] 117.67[/TD]
[TD] - [/TD]
[TD] Column H & J shouldn’t be Negative [/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]1-Jan-18[/TD]
[TD]31-Dec-18[/TD]
[TD]74062[/TD]
[TD]01/4111/41/2017/15[/TD]
[TD] 360.00[/TD]
[TD] 2,000.00[/TD]
[TD] 30.00[/TD]
[TD] 166.67[/TD]
[TD] 60.00[/TD]
[TD] 333.33[/TD]
[TD] 166.67[/TD]
[TD] 1,666.67[/TD]
[TD] Column H & J shouldn’t be Negative [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]TOTAL[/TD]
[TD] [/TD]
[TD] 71,702.13[/TD]
[TD] [/TD]
[TD] 45,048.11[/TD]
[TD] [/TD]
[TD] 51,942.66[/TD]
[TD] 6,894.55[/TD]
[TD] 19,759.47[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
I have given you some formulae which replicate most of your numbers, which I took as being correct. But now you're saying that some of the numbers you've given us aren't correct?

Based on your latest post, I am guessing that F9 should be =DAYS360(B19,1+C19). This gives 360 days for all these possibilities:


Book1
BCDEF
91 Apr 201731 Mar 2018360
101 Mar 201728 Feb 2018360
1115 Feb 201714 Feb 2018360
121 Mar 201529 Feb 2016360
1312 Mar 201811 Mar 2019360
1417-Aug-1716-Aug-18360
1527-Aug-1726-Aug-18360
Sheet1


But this would imply that most of the numbers you have posted are incorrect. Where do these numbers come from?
 
Last edited:
Upvote 0
StephenCrump said:
I have given you some formulae which replicate most of your numbers, which I took as being correct. But now you're saying that some of the numbers you've given us aren't correct?

Based on your latest post, I am guessing that F9 should be =DAYS360(B19,1+C19). This gives 360 days for all these possibilities:

BCDEF

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]9[/TD]
[TD="align: right"]1 Apr 2017[/TD]
[TD="align: right"]31 Mar 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]1 Mar 2017[/TD]
[TD="align: right"]28 Feb 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]15 Feb 2017[/TD]
[TD="align: right"]14 Feb 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]1 Mar 2015[/TD]
[TD="align: right"]29 Feb 2016[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]12 Mar 2018[/TD]
[TD="align: right"]11 Mar 2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]17-Aug-17[/TD]
[TD="align: right"]16-Aug-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]27-Aug-17[/TD]
[TD="align: right"]26-Aug-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

</tbody>




But this would imply that most of the numbers you have posted are incorrect. Where do these numbers come from?
Click to expand...

Can you please guide me how I can upload my excel sheet with you for your review. thanks
 
Upvote 0
NonStopLeo said:
Can you please guide me how I can upload my excel sheet with you for your review
Click to expand...

I would very much like to see this Excel file, too.

I suggest that you upload the file (redacted) to a file-sharing website (e.g. box.net/files) and post the public/share URL in a response here. Test the download URL first, being careful to log out of the file-sharing website. (If you use box.net/files, ignore any preview errors; just do the download.)

Some participants object to doing that because they cannot or will not be able to download the file. Too bad. An alternative is for you to post every (representative) formula, which is tedious. But sometimes, the devil is in details that we cannot see from posted formulas and values alone.
 
Last edited:
Upvote 0
StephenCrump said:
I have given you some formulae which replicate most of your numbers, which I took as being correct. But now you're saying that some of the numbers you've given us aren't correct?

Based on your latest post, I am guessing that F9 should be =DAYS360(B19,1+C19). This gives 360 days for all these possibilities:

BCDEF

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]9[/TD]
[TD="align: right"]1 Apr 2017[/TD]
[TD="align: right"]31 Mar 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]1 Mar 2017[/TD]
[TD="align: right"]28 Feb 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]15 Feb 2017[/TD]
[TD="align: right"]14 Feb 2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]1 Mar 2015[/TD]
[TD="align: right"]29 Feb 2016[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]12 Mar 2018[/TD]
[TD="align: right"]11 Mar 2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]17-Aug-17[/TD]
[TD="align: right"]16-Aug-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]27-Aug-17[/TD]
[TD="align: right"]26-Aug-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]360[/TD]

</tbody>




But this would imply that most of the numbers you have posted are incorrect. Where do these numbers come from?
Click to expand...

It is solved Sir. Just by a little modifications and adding 1+ in formula, it is giving the desired results now. Many Thanks for your help
 
Upvote 0
NonStopLeo said:
It is solved Sir. Just by a little modifications and adding 1+ in formula, it is giving the desired results now.
Click to expand...

Great, I'm glad you worked it out.

There are at least two people here curious to see what formulae you used in the end. Can you please post either a screenshot and the formulae used, or attach a workbook as joeu2004 explained in Post #6 ?
 
Upvote 0
joeu2004 said:
I would very much like to see this Excel file, too.

I suggest that you upload the file (redacted) to a file-sharing website (e.g. box.net/files) and post the public/share URL in a response here. Test the download URL first, being careful to log out of the file-sharing website. (If you use box.net/files, ignore any preview errors; just do the download.)

Some participants object to doing that because they cannot or will not be able to download the file. Too bad. An alternative is for you to post every (representative) formula, which is tedious. But sometimes, the devil is in details that we cannot see from posted formulas and values alone.
Click to expand...

StephenCrump said:
Great, I'm glad you worked it out.

There are at least two people here curious to see what formulae you used in the end. Can you please post either a screenshot and the formulae used, or attach a workbook as joeu2004 explained in Post #6 ?
Click to expand...

Dear Sirs

Here is my file
https://jumpshare.com/v/w0auT98281kUSe14O5fQ
Thanks again for your kind help.
 
Upvote 0
Thanks for posting your solution. It all looks reasonable, although you could simplify some of your formulae:

I9: =IF((DAYS360(E9,MIN(1+F9,I$4)))<0,0,(DAYS360(E9,MIN(1+F9,I$4))))
--> =MAX(0,DAYS360(E9,MIN(1+F9,I$4)))

J9:=IF(I9<=G9,(((H9)/G9)*I9),(((H9)/G9)*G9))
--> =H9*I9/G9
(The formula used in I9 means that I9 can never exceed G9)

And similar comments apply for K9 and L9.

You may also want to round your amortisations to the cent, so that you don't get rounding discrepancies.
 
Upvote 0
You must log in or register to reply here.

Similar threads

skyh3ck
  • Question Question
1st match column header, 2nd lookup a value in same column, 3rd return corresponding value from the very first column ?? need help
Replies
2
Views
546
skyh3ck
skyh3ck
M
  • Question Question
suggest excel formula to calculate cumulative interest on no of days etc ......
Replies
1
Views
648
Peter_SSs
Peter_SSs
A
  • Solved
AVERAGEIFS with 4 criteria
2
Replies
16
Views
750
Fluff
Fluff
E
  • Solved
Excel formula to count NEW unique names per month
Replies
5
Views
220
Fluff
Fluff
S
  • Solved
How to split week between month?
2
Replies
10
Views
2K
James006
James006

Forum statistics

Threads
1,223,896
Messages
6,175,263
Members
452,627
Latest member
KitkatToby

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top