Help

Days between dates

Topic Labels: Dates & Timezones
36522 22
cancel
Showing results for 
Search instead for 
Did you mean: 
Max_Cordell
5 - Automation Enthusiast
5 - Automation Enthusiast

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

22 Replies 22

I just tried WORKDAY_DIFF({Date of Return}, {Date Resolved}) and now it is showing negative days?

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!

IF({Date Purchased}, DATETIME_DIFF({Date Depleted},{Date Purchased},'days'))