I have an application where I want to create an item on a board. When this happens I will use automation to set one of the date columns to the date that was in the item (from another board) that will trigger this automation. I would ALSO like to have this new item (on a new board) pull in the original date, but also set another date column to the business day before the original date.
For example I trigger an automation for Item A which has a “Bid Date” of May 22nd, 2023 (which is a Monday). This will create a new item on another board which will have another column titled “Due Date” which will need to be the business day before the “Bid Date”. So in my example, a “Bid Date” of May 22nd would result in a “Due Date” of May 19th (the business day before the “Bid Date”).
I am not worried about holidays on this, I just wanted to see if there was a way to do this with a 5-day business week. I poked around with the formula column a bit but was not immediately seeing how I could do it with that, plus I think that would result in loss of functionality since it would no longer be a “Date” value? Thanks!