MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help!! When subtracting...


Posted by Steve on July 06, 2001 1:29 PM

I am subtracting 2 dates, to get the total days between the dates. How can i automatically account and subtract fot the weekends, if possible, can i account for holidays?
Thanks!


Posted by Kierrica Firson on July 06, 2001 1:36 PM


I think I ran into the answer to your problem during my own research. Try here:
http://www.cpearson.com/excel/DateTimeWS.htm
at the bottom of the page it has a link to help with Holidays.

Posted by Aladin Akyurek on July 06, 2001 1:44 PM


=NETWORKDAYS(A1,B1,HOLIDAYS)

HOLIDAYS is the name you can give (via the Name Box) to the range where you list holiday dates that you don't want to be counted in the difference. This function requires that the Analysis Toolpak add-in be installed (via Tools|Add-ins).

Aladin