Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing holidays and weekends , networkdays
I'm trying to use this function but it keeps returing the number of actual days, its not removing the weekends or holidays that I put in. one column date format is in yyyy-mm-dd, the othe rin mm/dd/yyyy I tried changing to both mm/dd/yyyy but didn't help. Can anyone help me? -- amyk1313 ------------------------------------------------------------------------ amyk1313's Profile: http://www.excelforum.com/member.php...o&userid=34943 View this thread: http://www.excelforum.com/showthread...hreadid=546774 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing holidays and weekends , networkdays
Give us the data and the formula you tried. It sounds like one of them is
text, not being recognised as a date. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "amyk1313" wrote in message ... I'm trying to use this function but it keeps returing the number of actual days, its not removing the weekends or holidays that I put in. one column date format is in yyyy-mm-dd, the othe rin mm/dd/yyyy I tried changing to both mm/dd/yyyy but didn't help. Can anyone help me? -- amyk1313 ------------------------------------------------------------------------ amyk1313's Profile: http://www.excelforum.com/member.php...o&userid=34943 View this thread: http://www.excelforum.com/showthread...hreadid=546774 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) | |||
Use networkdays INCLUDE weekends, Exclude holidays | Excel Worksheet Functions | |||
Schedule to exclude weekends and holidays | Excel Discussion (Misc queries) | |||
Formula - Excluding weekends & holidays | Excel Worksheet Functions |