4 Replies Latest reply on Aug 17, 2012 12:59 AM by Cathal Henry

    How do I exclude certain dates in a calculation

    Cathal Henry

      I have a spreadsheet with a list of dates in the year, each is marked either 0 or 1 depending on whether or not it is a working day for our company.

       

      I have a separate data source which I am using to calculate average days to complete various work types based on a work item created date and completed date. I want to join the spreadsheet data with this data and exclude the dates marked as 0 (non working days).

       

      I have a formula for excluding weekends which works fine but there are other non working days I also want to exlude which is why I have the spreadsheet.

       

      Any help would be appreciated.

      Thanks

      Cathal