G Guest Apr 14, 2006 #1 I need help with this formula please Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX
I need help with this formula please Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX
D Douglas J. Steele Apr 14, 2006 #2 =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.
=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 Apr 14, 2006 #3 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
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
