See the NETWORKDAYS and WORKDAY functions. These are part of the
Analysis Tool Pack add-in, so you must have this loaded to use
the functions. Go to the Tools menu, choose Add-Ins, and put a
check next to "Analysis Tool Pak".
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"S trainer" <S
wrote in
message
...
how can I do "Date math" using only business days?