3 Replies Latest reply: Apr 19, 2011 8:16 AM by Anne Duffy RSS

    Days count from today



      'Number of Days selected '&num(NetWorkDays(min(Date),max(Date)))


      Hi Guys

      I have a text box to cout the number of working days selected, however I have data loaded in to forcast . What the above formula is doing is counting all dates, it works when specific dates are selected, but when nothing is , it is counting all available dates including dates in the future.

      Is it possible to change it so it counts the selected dates , and defaults at number of days in the past until today -1

      Please help !!!!