View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Formula for dates minus the weekends

look at networkdays() in help. note you must have the data analysis addin
activated for it to work.

"TJH" wrote:

I need help finding a formula that will figure out the days minus weekend days.

Ex: Due date Ship date #of days early # of days late
4/16/07 4/26/07 7

I would like for the # of days early or # of days late to give me a # BUT
not counting weekend days. Is there anyway to do this?
--
TJH