Need to Create a Custom Calculation Script
OK so I created a form and I'm stuck in the calculations. I have a start date, an end date and a dollar amount. I need to calculate a dollar amount based on the number of days.
Example:
Start Date is 8/1/21
End Date is 8/4/21
Dollar Amount is $200
So the easy way to explain is 8/1/21 through 8/4/21 is 3 days... 3 days * $200 is $600
The dates and dollar amount will be entered by the employee and the result of $600 will automatically be calculted.
How can I accomplish this?