Google Sheets Help

[Matheuspdo]

Hello, I need to make a spreadsheet but I'm still new to Google Sheets. I would like how it would be to make a spreadsheet that: from an initial date, put the number of days you want, then show the end date (except for the holidays I put and also weekends). At the end I would like you to show the end date, excluding holidays and weekends. The attached image shows the calculation of all days. I would like to put exceptions
Thank you very much in advance.

 

[jasonb75]

In excel, you would use the WORKDAY function, I believe that google sheets has the same function. Weekends are excluded as standard. A list of holidays can also be added as needed.

Book1
	E
1	01/01/2021
2	15
3
4	22/01/2021
Sheet4

Cell Formulas
Range	Formula
E4	E4	=WORKDAY(E1,E2)