title: Does Excel have a function to calculate Canadian federal holidays?
body: <p>I'm trying to figure out how to calculate the past/future Canadian federal holiday dates to use the <code>NETWORKDAYS</code> function in the cell. Because the dates of the holidays change every year, is there a function or VBA code that I can use to calculate this?</p>
  
  <p>For example, I have a 10 year project and I want to calculate the variance between the beginning date and the end date, excluding the weekends and holidays.</p>
  
  <p>Like, Civic holiday is on the 1st Monday of August. It was on the 1st in 2011, but in 2012 it was on the 6th. </p>
  
  <p>Easter Monday was on the 25th in 2011, but on the 9th in 2012. </p>
  
  <p>Becuase <code>NETWORKDAYS</code> need exact date of the holidays in order to work, I need to calculate the future holiday dates (10-15years into the future)</p>
  
  <p>I hope this makes sense...</p>