what I am trying to do is formulate a houskeeping run sheet for a boarding
house

"wolfmasterr" wrote:

> yes $13.57 = 1 day the money amout goes into C1 with the day value going into
> E1 with the same happening down to E32. what I need is a way of adding days
> to a date that has aready been input to cell d1-d32. As stated I am hopless
> with this
>
> "Neil" wrote:
>
> > Not much information here to go on, how does $95 = 7Days,? Is it $13.57 per
> > day? and is that constant?
> >
> > Assuming that to be the case,
> > Simply put the dollar amount in a cell e.g. A2, and in your target cell (B2
> > for instance) type the formula =A2/13.57
> >
> > You will probably want to format your dollar cells as currency to give them
> > the dollar sign, and If you're looking for whole numbers of days, you will
> > have to set the correct number of decimal places on the calculated cell (B2)
> >
> > HTH (If not, post back)
> >
> > Neil
> > www.nwarwick.co.uk
> >
> > "wolfmasterr" wrote:
> >
> > > I need to write a formula to convert a monetary value(given) and have it give
> > > back a value in days eg: $95 =7days
> > > I am very new at this and all of the atempts I have made are complete failures