title: changing a static date range into a dynamic date range in excel
body: <p>I am trying to replace a static date range into a dynamic range. Currently I am using    <code>=COUNTIFS(Referrals!$E$3:E$325,"IT/TWE",Referrals!$A$3:$A$325,"&lt;11/1/15")</code> &amp;    <code>=COUNTIFS(Referrals!$E$3:$E$325, "IT/TWE", Referrals!$A$3:$A$325, "&gt;=11/1/15", Referrals!$A$3:$A$325, "&lt;=11/30/15")</code>.  <strong><em>Referrals!$A$3:$A$325</em></strong> is the date column &amp; the date is entered by the user. In the past I would change the year manually. The second formula is the same for the other 10 months. Is it possible to do what I am asking? I have found various things related to dynamic ranges, but nit related to dates.</p>