In our production process, we have the following dates (simplified view):
- Production Start Date: Feb. 3
- Build Date: Feb. 10
- Production End Date: Feb.20
The build date is always 5 business days after production start date.
I’m trying to build a GI that will list out these dates but I don’t seem able to create a formula that does AmProdItem.StartDate + 5 Working Days.
I can do AmProdItem.StarDate + 5,but it will include weekends. Is there anyway to do this but exclude weekends? Or anyway to incorporate one of the work calendars into this calculation?
Best answer by aaghaei
View original