NETWORKDAYS and excluding vacation/PTO time used
 

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

NETWORKDAYS and excluding vacation/PTO time used
 

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

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