how do i calculate the number of weekdays between two dates in excel?
A Aladin Akyurek Oct 18, 2004 #2 =NETWOKDAYS(Date1,Date2) where Date1 <= Date2. You need to activate the Analysis Toolpak add-in.
P Peo Sjoblom Oct 18, 2004 #3 Try NETWORKDAYS =NETWORKDAYS(start,end,holidays) you need ATP (analysis toolpak) installed if you get a name error click tools>add-ins and check Analysis ToolPak, keep the excel/office CD handy and follow the instructions Regards, Peo Sjoblom
Try NETWORKDAYS =NETWORKDAYS(start,end,holidays) you need ATP (analysis toolpak) installed if you get a name error click tools>add-ins and check Analysis ToolPak, keep the excel/office CD handy and follow the instructions Regards, Peo Sjoblom
