How to split a number of days into "days upto 6 months" "days upto 12 months" and so on

[borkarrr]

Hello friends
i have a date in a cell say for example 06/09/2014 (due date)

i have another date in a cell below for example 18/07/2015 (date of payment)

in the cell below i have calculated the delay beetween two dates which is 315 days---

Now i would like to split these 315 days as-

no.of days delayed upto 6months from 06/09/2014 (ie the due date)
(answer should come as 184)

no.of days delayed from 6months to 12 months
(which is due date + 6months ie delay from 06/03/2015 to 18/07/2015)
(which should come as 181)

No of days delayed above one year from due date
(ie 06/09/14 + one year - date of payment)
(ok this one comes as zero :P)


Basically i want it because i want to calculate interest on service tax which has different rates of interest penalty depending on delayed days--
upto 6months - 18% interest
6months to one year - 24% interest
12 months above - 30% interest

is there any way to do this without using vba as im not really comfortable with it...

looking for help from you guys im really stuck

 

[gaz_chops]

Try
6mth
=IF(EDATE(B1,6)>B2,B2-B1,EDATE(B1,6)-B1)

12mth
=IF(EDATE(B1,12)>B2,B2-B1-B5,(EDATE(B1,12)-B1)-B5)

>12mth
=IF(B2>EDATE(B1,12),B2-B1-B5-B6,0)

[TABLE="width: 171"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]01/04/13[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]18/07/15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]838[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6 Months[/TD]
[TD="align: right"] 183[/TD]
[/TR]
[TR]
[TD]12 Months[/TD]
[TD="align: right"] 182[/TD]
[/TR]
[TR]
[TD]> 12 Months[/TD]
[TD="align: right"]473[/TD]
[/TR]
</tbody>[/TABLE]

 

[borkarrr]

Thanks mate i tried using IF and EDATE but sometimes i used to get wild answers ...
your version looks really foolproof which is providing reliable answers everytime

btw youve really reduced my efforts to calculates taxes thanks alot again

 

[gaz_chops]

You're very welcome.