Return the Workdays

[xlhelp15]

Hi Expert - Would need your kind assistance for the below condition.

Column A2:A5 has dates in mm/dd/yy format and Column B2:B5 has 10, 15, 20, 30 respectively.

In column C2:C5, I would need an output which should return the Workdays date by adding it.

For eg, if A2 has 09/21/22 and B2 has 12 in number, it should return date adding the 12 days by excluding weekends which is 10/07/22.

Kindly help me on this, please.

 

[xlhelp15]

I tried workday function, but it returns #VALUE Error.
=WORKDAY (A2,B2)

 

[Phuoc]

Try entering this value in A2:

2022/09/21

 

[Dave Patton]

Workdays.xlsm
	A	B	C
1
2	21-Sep-22	12	7-Oct-22
3	21-Sep-22	15	12-Oct-22
4	21-Sep-22	20	19-Oct-22
5	21-Sep-22	30	2-Nov-22
6
4c

Cell Formulas
Range	Formula
C2:C5	C2	=WORKDAY(A2,B2)

Ensure that you have dates in Column A and not text that looks like dates.

 

[xlhelp15]

Thank you @Dave Patton & @Phuoc - It worked !!!!