Excel Microsoft excel interest formula

[ravisoni]

hay there plz help me if any one would be able to provide me the excel formula for the following.


calculation of compund intrest between two dates
1.--where it automatically calculates the time between two dates....
2---compund the intrest half yearly
3...nd nd nd with a specif condition that for example....3 months 16 days shall b considered as 4 months(more theen 15 days in any month shell be considered as complete month)
but less then 15 days shall not be considered as complete
ie.. the differen between two date id 4monts 12 days------- intrest shall be calculate for 4monts 12 days
the difference between two dates is 4 months 16 days----- intrest shall b calculated FOR 5 MONTHS

 

[strvitracer]

You have to setup equations for those conditions and apply it. Atleast that's the only way I know(not an excel expert, just average).

 

[ravisoni]

tnx ... m also not an expert so...