Removing holidays and weekends , networkdays

[amyk1313]

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?

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>