Dates Less than 1 duration
Trying to get a formula to calculate less than day if duration is less than 1 whole day.
Start date is 7/30/2018
End date is 7/30/2018
Duration is .12d
Formula Variable Date is 8/14/2018
If I want to run a formula to calculate the days from Variable date less end date - I get 15. I am looking for something more exact...should be 14.88.
Any help would be appriciated
Help Article Resources
Check out the Formula Handbook template!