I need a formula to Subtract Today from a date and return the difference in weekdays only if another field is blank

Question

I need a formula to Subtract Today from a date and return the difference in weekdays only if another date field is blank. So basically I want to know how many days late an order is if it hasn't shipped. I have a order due date field and a ship date field.

So I want to count the number of working days past due if the ship date field is blank.

Thanks for your help.

chrischris · Answer

Formula Numeric field would go like --if(isnull([ship date]),weekdaysub(Today(),ToDate([order date])),null)

scottgraham · Answer

Thank you for the help. I am getting the following error.
The types of the arguments or the number of arguments supplied do not meet the requirements of the function ToDate.

The function ToDate can be used with the following arguments:

ToDate (Text x).
ToDate (Text x, Text f).
ToDate (Date/Time x).

chrischris · Answer

The [Order Date] field may already be a Date type, so just remove the function ToDate() that is wrapped around the [Order Date] field.

scottgraham · Answer

So this is what I have now and it is not returning a value.if(isnull([Ship Date]),weekdaysub(Today(),([Booked Date])),null)

scottgraham · Answer

I was able to get it to work by changing the formula type. Thank you!

Forum Discussion

I need a formula to Subtract Today from a date and return the difference in weekdays only if another field is blank

7 Replies

Related Content

Same reference field, different selections within the form

Formula to find weekdays for a duration

WEEKDAY function

Formula to calculate weekdays

Subtracting

Recent Discussions

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting