i want to know a formula in excel
period
30 march 2009 to 30 april 2009 rate of int 8% pa amount 100000.00
calculate the interest of the above period
formula like this
= 100000.00*0.08/365* here i want to add days that i dont want to calculate manually that should be come in the formula
Menu
formula in excel
Replies (2)
Firstly change the date format to dd.mm.yyyy for both the dates (in format--> Cell)
Then simply deduct the dates and change the result column into number format.. and add 1 into it to get the correct no. of days ....
Its really easy... Just put one date ni one cell e.g. 30/03/2009 in A1 cell. Then put another date in B1 cell. Then give formulla in C1 cell. Formulla = B1 - A1... You will get the answer in number fromat. If not then you can change the format of the formulla cell into number format.
After that you can use the same i.e. C1 cell for your Original formulla. Ashish
Recent Threads
- Form 26QB error, how to claim refund
- Turnover limit for goods & service
- Conversion of old B2Cs invoices to B2B
- Tax implications on brokerage
- Showing f&O loss and intraday profit in ITR
- REBATE RECEIVED FROM FOREIGN PARTY AFTER MAKING PA
- How to fill in csv file for Schedule 112A
- Gst 2a and Gst 3b difference
- What happens if a taxpayer forgets to file ITR but
- ITR 2 / Schedule FA / Income tax
Related Threads
CAclubindia
