title: Excel Tricky date based formula required - Experts Please assist
body: <p>I need to add the total of sales done per month. That is add figures in column 2 if dates fall between 1st of every month till 31st.</p>
  
  <p>This should be current. That is if May ends and June begins excel should automatically stop calculating figures of may and only tally the ones from june till june end and so on for all months and following years</p>
  
  <p>Is this possible or too complicated</p>
  
  <p>Please note I follow this date pattern: dd/mm/yy or dd.mm.yy</p>