View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Nancy S[_2_] Nancy S[_2_] is offline
external usenet poster
 
Posts: 2
Default Forumlas for Dates

I need to know the # of workdays between 2 dates (I know of the NETWORKDAYS
function).
The problem is that if one of the days in that range falls on a Fri, I need
to subtract 1 more day from the workweek.

It appears the WEEKDAY function does not allow you to consider a range of
dates, only a specific date.

One option I thought of is including all Fri dates in the holiday field when
building the formula so it will exclude those dates.
This will be a bit time consuming. Any other ideas???