Duration of 2 dates calculated with only business ...

[Dean_Harris]

I’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!

[JonathanBowen]

Hi @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.