Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate time (excluding weekend (48 hrs)) | Excel Worksheet Functions | |||
Calculates Dates Based on 7 day week excluding Holidays | Excel Discussion (Misc queries) | |||
Can this even be done? Tracking Date / Time Elapsed | New Users to Excel | |||
Time between two dates (Excluding Non-bus Hrs) | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |