Hi, all.

I am fairly new to the function, NETWORKDAYS, however I have been able to
use it figure the number of days between two dates excluding my list of
holidays. I would like to set the formula to also exclude a list of dates
that are the reps PTO/vacation time too. Can anyone help with adding this
additional step to the formula?

Also, I am setting up an IF formula in my spreadsheet so that the text in
column C is converted to a numeric value in column D. However, I need the
formula to include all the different types of report text (i.e. AoE, ADD,
Consult) from column C and not just one. How can I include all of these into
the formula?

Any assistant would GREATLY appreciated.
--
EvieB