Hi - I am trying to add a date to a file that is currentdate - 1 but need it to calculate the date for the prior business date or weekday. For example, on Monday, the date should be the date of the prior Friday. On Tuesday, it should be the date for Monday etc. I see information based on calculating the difference between days but do not see how to use that as a solution. Any suggestions? It seems like a common request.
Hi Joe,
I sent you a reply directly but also wanted to link you to this community post: Subtract 2 Business Days From Date
@Emory_Stainbrook came up with a nifty idea for that one, so let us know if it’s helpful!