calculate payment with first payment due date variable?

G

Guest

I need to be able to calculate a payment with the ability to input the first
payment due date as a variable. for example due date would be in 45 dates
from current date.
 
G

GeorgeF

Jody,
If the current date is in A1 from a key-in, reference from another cel
or using NOW(), then in B2 place =A1+45. This will show a calenda
date 45 days after the date shown in A1. Should A1 change, B1 wil
change accordingly. Be sure the cells are formatted the same from th
many Date choices in the Format drop-down.
I hope I interpreted your problem properly. George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top