Help with Weekday Formula

[Aqua1967]

I have a form that has dates that need to be populated based on a numerical code placed into cell H46. I have the number of days for the 13 codes listed on another tab called Dates. The formula I'm currently using takes weekends into consideration and I only want the dates to count weekdays. Can someone please help me integrate the WEEKDAY formula into the formula I'm currently using?

The dates I need to populate begin in cell O49 and go through O57. Here's the formula example for the first cell to be populated by a date:
=$O$48+VLOOKUP(H46,Dates!A20:B32,2,0)

Is there a way to modify this formula to only include weekdays in the counts and skip the weekend days?

Any help is greatly appreciated. Many thanks to you, in advance.

 

[shyy]

For weekdays use the WORKDAY function Excel WORKDAY Function

 

[Aqua1967]

But how? Where do I put it in my existing formula? Please let me know. Thank you.

 

[barry houdini]

Duplicate thread - closed