NETWORKDAYS and excluding vacation/PTO time used
Thank you, Teethless mama. However, I have to keep my dates separated so is
there a way to add the additional column? (H1:H30=holidays and
I1:I15=vacation/sick/pto days).
--
EvieB
"Teethless mama" wrote:
A1: start date
A2: end date
A3:A10 your Holidays and PTO/vaction
=NETWORKDAYS(A1,A2,A3:A10)
"evieb" wrote:
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
|