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


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


