writing a formula

[Guest]

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 Harkawat]

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

 

[JE McGimpsey]

One way:

=D1 + INT(C1/13.57)

Format as a date.

 

[Bob Phillips]

I thought we solved this yesterday?