VLookups and Filling Weekdays only

[suzysooz]

Hi, first time poster and basic excel user so please be gentle with me.....

I have done a V-lookup that auto populates my project report doc with different lead times/dates depending on the product selected. Problem I have it that the dates being pulled through are for all calendar dates and not just working week days.

I know you can select a selection of dates and fill as week days however all of the dates on my primary sheet either have the project start date minus lead time formula or the vlook up formula in it. Filling week days overwrites any of this.

I hope someone can help???

Thanks

S

 

[Andrew Poulsom]

Welcome to MrExcel.

I'm not sure that I completely understand your problem, but you can use the WORKDAY function to add/subtract only working days from a given date. Prior to Excel 2007 the function is in the Analysis ToolPak Add-In, which must be installed.

 

[suzysooz]

Thank you Andrew - I'm using 2010. How does I start using the WORKDAY function?

 

[Andrew Poulsom]

It's built into Excel 2010.