writing a formula
 

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

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



"wolfmasterr" wrote in message
...
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

One way:

=D1 + INT(C1/13.57)

Format as a date.

In article ,
"wolfmasterr" wrote:

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

I thought we solved this yesterday?

--
HTH

Bob Phillips

"wolfmasterr" wrote in message
...
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