Formula to show number of days left

Ask the Community Formulas
#1

Looking for a suggestion on how to best achieve the following:

I have an order date, say “4th July 2018” and i have 3 workdays in which to complete the order.

I’d like the formula to say “3 days left” or “2 days left” depending on today’s date.

WORKDAY({Order Received},3) will give me the due date. But how to calculate the number of days left until we hit the due date?

#2

Hi there,

Please try this formula below:

DATETIME_DIFF((WORKDAY({Order Received},3)),TODAY(),'days') & " days left"

Hope this helps!