Forum Discussion

Candi80's avatar
Candi80
Copper Contributor
Jan 04, 2024

=Today Function within a formula

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.

 

excel
Formulas and Functions

2 Replies

    • Candi80's avatar
      Candi80
      Copper Contributor
      Jan 04, 2024

      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.

Resources