Removing holidays and weekends , networkdays

Giganews Newsgroups
Subject: Removing holidays and weekends , networkdays
Posted by:  amyk1313 (amyk1313.28mp3c_1149006006.0851@excelforum-nospam.com)
Date: Tue, 30 May 2006

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