date (minus) date = working days diff
Hi
Try =NETWORKDAYS(firstdate,seconddate,holidays)
Networkdays is part on the Analysis Toolpak so go to ToolsAddins and
ensure Analysis Toolpak is selected.
Substitute the cell reference holding your earliest date for firstdate, and
the cell ref for your latest date fro seconddate.
Holidays is either a list of cells containing public holidays, or a named
range containing the holiday dates.
Regards
Roger Govier
jjj wrote:
Hello All,
Quick and easy one (I hope), i have two dates how can i work out the
working days between them ?
Kind Regards
JJJ
|