date difference calculation

C

Claire

I need help with this formula please
Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX
 
D

Douglas J. Steele

=DateDiff("d", Date(), ReturnDueDate) * .01 * valueX

There's no need to include the $1.00 in the calculation, since multiplying
by 1 won't change anything.
 
J

John Spencer

If you mean you want to calculate the number of days late (or early) and
multiply that by one percent of the value of something then the formula
would be.


DateDiff("d",[ReturnDueDate],Date()) * [ValueofX] *. 01
 
Top