Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,718
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate time (excluding weekend (48 hrs)) AndyO_UK Excel Worksheet Functions 10 February 3rd 07 08:55 PM
Calculates Dates Based on 7 day week excluding Holidays Daviv Excel Discussion (Misc queries) 1 January 17th 07 08:02 PM
Can this even be done? Tracking Date / Time Elapsed scd New Users to Excel 6 February 3rd 06 08:44 PM
Time between two dates (Excluding Non-bus Hrs) lnapier Excel Worksheet Functions 0 July 13th 05 03:15 PM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 08:18 PM


All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"