Help

Formula to determine days remaining until a due date

Topic Labels: Formulas
694 3
cancel
Showing results for 
Search instead for 
Did you mean: 
RyanCP
4 - Data Explorer
4 - Data Explorer

Hey guys,

Just trying to work out a simple Formula to create a day count until a certain date (based on one of our fields) without including weekends. For example. We have a customer due date for an order which is put into a field, just wanting to have a field that calulates how many days we have for production until that date. 

So far I have:

 

DATETIME_DIFF(
  {Due Date},
  TODAY(),
  'days'
)

Which works fine but is including weekends. To combat this, I did try:

WORKDAY_DIFF(
  {Due Date},
  TODAY(),
  'days'
)

But this is throwing an #ERROR. I know I am definetly missing something. 

Any help is appreciated.

 

3 Replies 3

Hi @RyanCP,

You are seeing that error message because the formula syntax is not correct. To resolve this, you should use the following syntax: WORKDAY_DIFF({Due Date}, TODAY(), 'holidays') where 'holidays' is a list of holiday dates that you would like to exclude in this format: "2022-01-01, 2022-01-17" - you do not need to add weekends to the holidays list because those are excluded by default.

I hope this helps!

Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com

Hey @Alessio_Monino 

So I have entered that formula and it's still throwing an error. 

WORKDAY_DIFF(
  {Due Date},
  TODAY(),
  'holidays'
  )


Do I need to enter dates?

Hi @RyanCP ,
you can either add the dates in the 'holidays' text or leave that option entirely blank so for example either:


WORKDAY_DIFF
(
  {Due Date},
  TODAY()
  )

OR

WORKDAY_DIFF(
  {Due Date},
  TODAY(),
"2022-01-01, 2022-01-17"
  )

Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com