Extracting days (excluding weekends)

Question

Hi Team,

Hope you are well.

I need help.

I have two date fields.

a) Cntr_creation_date

b) Issue date

My workflow should have a formula tool which can calculate and display records  that were entered more than 2 days
(excl. weekends and public holidays) after the Cntr_creation_date.  Means the contracts which are entered in the system after 2 days of actually creating the contract.

i think there it should be difference between the Cntr_creation_date and the Issue date.

i have a formula below can you please let me know if this does the same thing,

((DateTimeDiff([ISSUEDATE],[Cntr_creation_date],"days")*5 - (ToNumber(DateTimeFormat([Cntr_creation_date], "%w"))-ToNumber(DateTimeFormat([ISSUEDATE], "%w")))*2) / 7) + IIF(DateTimeFormat([ISSUEDATE], "%w")=="6",-1,0) +
IIF(DateTimeFormat([Cntr_creation_date], "%w")=="0",-1,0)

Thanks

SR

aatalai · Answer

@sriniprad08 more tools, but this might be slightly easier to follow

Extracting days (excluding weekends).yxmd

sriniprad08 · Answer

Hi@binu_acs thanks for the reply. Can you please help me with understanding what each expression does. especially why we multiply by *5 in the first expression

1) ((DateTimeDiff([ISSUEDATE],[Cntr_creation_date],"days")*5 -

2) (ToNumber(DateTimeFormat([Cntr_creation_date], "%w"))-

3) ToNumber(DateTimeFormat([ISSUEDATE], "%w")))*2) / 7) +

4) IIF(DateTimeFormat([ISSUEDATE], "%w")=="6",-1,0) +
5) IIF(DateTimeFormat([Cntr_creation_date], "%w")=="0",-1,0)

binu_acs · Answer

@sriniprad08 yes, it only excludes the weekends not the public holidays