2 Replies Latest reply on Jun 8, 2016 6:10 AM by Matthew Hefferon

    Compare Previous Years Sales with Current Date

    Matthew Hefferon

      Hey Guys!

       

      I'm hoping someone can help me with a calculation... I need to compare June sells against June 2014 and June 2015.

       

      bar.PNG

      The problem with the image above is we are comparing 7 days of June with the full month of June for 2014 and 2015.  I'd like to compare June 2016 against June 2014 and 2015 but not for the full month. I've attached a sample workbook.

       

      Thanks in advance!