Need help with NETWORKDAYS

[jwhite99]

The project I'm working on has a spot for a date to be entered by the user, and will pre-populate work days (not including holidays as well) that are relevant to when things will happen in a series. So for example, if the user enters a date of 12/10/2011, one of the items is that date plus 3 days. They have to be stock market trading days, though. I've seen how to use the NETWORKDAYS formula to get the NUMBER of days between two dates excluding weekends and holidays, but I haven't seen anything like what I'm trying to do. Can anyone out there help me? I'll attach an example. Please help!

[Bob Phillips]

Tell me again, what is so different in what you are trying to do?

[PeteZA]

Use workday:

Please Login or Register  to view this content.

From your spreadsheet. You will need to separately do a table of public holidays, and this will then be referenced after the number of days:

Please Login or Register  to view this content.

[jwhite99]

That worked perfectly - thank you!