date difference calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with this formula please
Todays Date - ReturnDueDate= difference in days * $1.00 * .01 of valueX
 
=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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to use the IF and SUMIF function on Excel 8
Can anyone translate this SQL statement for me? 2
Help with debugging query (Rolling Average) 7
if statements 3
Excel How to calculate in excel number of open actions that expired (older then today) 0
Excel Date Count 2
Make query to calculate two dates 2
Please , help me 1

Back
Top