Skip to main content

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!

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.

Reply


Terms & Conditions