=Today Function within a formula

[Candi80]

I have 1 more question. Daily interest I have as =(G2*0.0925)/360, How can I get another formula to calculate so the total that changes with today's date. To go into the interest paid J column? So every time i open it the total will be current from date purchased?

Thanks in advanced for the help.

[#2]

Isn't this the same as your other question if function help ?

[#3]

Yes, But i am new here and didn't know if you got my reply on the other one since I stated it was the best response first. Thank you again they all worked perfect.