Subtract one workday

[Keyuser]

Hy,

I’m loading a date field in my script.
Example: 01.05.2020

Now I need a second date field where I calculate following:
Date minus one workday.

Example: 29.05.2020

Thank you!

[tresesco]

I guess you meant - Example: 01.06.2020

FirstWorkDate(datefield, 1+1)  as date_minus_a_workday

[Taoufiq_Zarra]

@Keyuser 

May be

=firstworkdate (Field, 3)

[Brett_Bleess · Accepted solution]

You have received two posts related to your use case, if either of them got you what you needed, we would greatly appreciate it if you would return to the thread and close things out by using the Accept as Solution button on the post(s) that helped you resolve things.  If you did something different, you can post that in a new comment and then mark that too, and if you still have questions, please leave an update post.

Regards,
Brett