Please help!!
I know this is wrong, i cant seem to figure it out. my first question regarding interest earned is, i would like to basically input original amount say 10000 on jan 1st 2013 on jan 3rd 2013 my new value is 10065. How do i calculate my interest rate so far..
2nd question i think is simpler, i want to create a cell to auto fill with date when i type 2 or 12 to fill 2013/01/2 or 2013/01/12 and than change the formula so when i hit february i can still just type 28 and it will do 2013/02/28.
Any ideas here are sheets to see my examples
please any thoughts or ideas let me know.
test.xls
Bookmarks