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