Mar 21, 2016 09:33 AM
Can anyone tell me the formula for calculating the number of days between “date logged” and “date completed”. And if the formula could be expressed as working weekdays only that would be icing on the cake! Many thanks
Aug 05, 2019 09:00 PM
I just tried WORKDAY_DIFF({Date of Return}, {Date Resolved}) and now it is showing negative days?
Jun 22, 2020 09:16 AM
This formula is what I’m looking for. However, I may not have a date in the second field and currently it returns NaN if something is missing in the secondary field. Is there anything that could be added to leave the field blank if there is nothing in that field. In the example above it would be if the {Date Purchased} was blank then the output would be left blank.
Thanks!
Jun 23, 2020 01:28 PM
IF({Date Purchased}, DATETIME_DIFF({Date Depleted},{Date Purchased},'days'))