SQL waaaaay beyond my ability for date range
I have a custom for Period Close Activities. The user clicks a button at the start of the month end period and the record populates a sublist of 20 tasks. Currently the owner of each tasks goes in and puts in an expected end date. I want to prepopulate that expected end date field though.
I need a piece of SQL to use on a formula field to say end of current month plus/minus N days not including weekends.
Can anyone help with how I would achieve this please?