writing a formula

W

wolfmasterr

how do I write a formula that will allow me to input dollar amount in c1 and
then have excel divide that amount by 13.57 and convert the result into days
then also add that figure to a date already input into di and so on down the
columns
 
N

N Harkawat

On the desired cell type this formula and copy it down that column
=int(c1/13.57)+d1
 
Top