I need to show a date inside a form that is 3 business days from today. If today's date is Monday, March 21st, the calculated date would be Thursday, March 24th. I know that I can do that by using =DateTime.today.AddDays(3)
. However, if today's date is Thursday, March 24th, the calculated date would be Tuesday, March 29th, which is actually AddDays(5). How do I ignore Saturday and Sunday?
Bonus points if I can ignore holidays as well.