+5I’m wondering if anyone has thoughts on this problem. I’m currently using a WORKDAY formula to calculate the due date of project from the ordering date. However, if the deliverable is ordered after a certain time of day, let’s say noon, I don’t want the calculation to start until the following business day. In other words, I want it to calculate only full business days.
Anyone have any ideas on how this could be accomplished?
Thanks in advance!
+18Hi @Dean_Harris - you could calculate an “effective start date” based on whether or not the start time was after midday:
using the formula:
DATETIME_PARSE(
IF(
VALUE(DATETIME_FORMAT(Start, 'H')) >= 12,
DATETIME_FORMAT(DATEADD(Start, 1, 'day'), 'DD/MM/YYYY'),
DATETIME_FORMAT(Start, 'DD/MM/YYYY')
),
'DD/MM/YYYY'
) Then use this new date in your WORKDAY formula.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
