gambit Wrote:
Hi all
I need to work out the days left till the end of a certain date from
today and then add any holidays to that count if there are any between
now and then. My result shout be a number.
I live in South Africa so excel does not have the holidays here
entered, so I will need a way of adding these somehow.
Any help would be most welcomed.
-G
Hi Gambit,
Try the formula NETWORKDAYS, it returns the number of whole working
days between start date and end date. Working days exclude weekends and
any dates identified in holidays.
If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.
oldchippy :)
--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile:
http://www.excelforum.com/member.php...o&userid=19907
View this thread:
http://www.excelforum.com/showthread...hreadid=574137