Re: Removing holidays and weekends , networkdays

Giganews Newsgroups
Subject: Re: Removing holidays and weekends , networkdays
Posted by:  Bob Phillips (bob.N…@somewhere.com)
Date: Tue, 30 May 2006

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" <amyk1313.28mp3c_1149006006.0851@excelforum-nospam.com> wrote in
message news:amyk1313.28mp3c_1149006006.0851@excelforum-nospam.com...
>
> 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?action=getinfo&userid=34943
> View this thread:http://www.excelforum.com/showthread.php?threadid=546774

Replies

None

In response to

Removing holidays and weekends , networkdays posted by amyk1313 on Tue, 30 May 2006