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:
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.
