Search results

First I want to say that I love this website. Things are put in a way that even someone like myself that is not an expert can begin to understand how to create a dynamic spreadsheet. Okay, this is what I am looking for. What would the formula look like to come up with the IRR on a life...

First I want to say that I love this website. Things are put in a way that even someone like myself that is not an expert can begin to understand how to create a dynamic spreadsheet. Okay, this is what I am looking for. What would the formula look like to come up with the IRR on a life...

Thank you Narayan! This works great. All The Best

Azumi, as I change the Contract Date and the Condition, the Year, month and Day is incorrect. It works for the date that I gave but not any other date I put into the Contract Date. For example I put the contract date as 9/4/10 and the condition 5yrs and it states that there is 6 years, 11 month...

Azumi, this is perfect! Thank you......

Looking for formula............. Lets say we have a contract with an Original contract date of 01/01/2008 and this contract is for 10 yrs. How many YRs, MONTHs & DAYS Left from todays date.

Hello, SirJB7 and Luke M. Could one of you help me with this? I need to backdate by months and days not just by days. If my birthday is Dec, 15 I need to go back 6 months (does not matter how many days are in those months)which will be June, 15. Then by 4 days. The backdate then will be June...

I have run into a snag, I need to back date 6 calendar months and 4 days from upcoming birthday. If my birthday is Jan, 24 I need to go back 6 months to July, 24. (It does not matter how many days our in each of those months) and then 4 days which would be July, 20. This is the backdate that I...

I want to thank each one of you for your help. This will work great. It is good to see people passionate - and competitive I mite add - about their abilities in excel. This is an amazing website for an amazing software program. NARAYANK991 To your question, current age will be used. If you...

I am putting together a simple little calculator that tells me a clients "insurance age” and a backdate Date. A lot of life insurance carriers use “Age Nearest” when it comes to underwriting risk on life insurance. What this means is, if you are within 6 months of your next birth date...

Good Morning Day_I. I was replying to kchiba statement. (Second response to Hui) Everyone have a great and successful day!

Luke M. Thank you. I am creating a calculator for my team of internal wholesalers. My hope is that I can just input the Lump Sum and the number of years we would like for the account to pay out and the calculator will do the rest. It will be a itemized report that can be saved as a PDF and...

kchiba This site is not only for those that are excel experts that want to network and stroke each other to feel good about themselves. But also for those that are not familiar with excel at all. These individuals may not even know what to look for or where to begine searching for an answer...

I am looking for a financial formula with a little twist. Let say I want to Deposit a sum of money ($500K) into an account that earns a guaranteed interest rate that veries(GIR increases every 5 years by .5% Starting with a 1.5%) This account will pay out a level amount for a stated number of...