6 Replies Latest reply on Aug 2, 2016 9:33 AM by Jin Wu

    academic year problem

    Jin Wu

      Hi I have two sets of date in one excel file, from 7/1/2014 to 6/30/2016. I work at a university which academic year starts on 7/1. When I try to compare two academic year, 7/1/2014-6/30/3015 and 7/1/2015-6/30/2016, for example, drag the date to the "color", it shows 2014, 2015, and 2016. How can I only compare two time range instead of three?

       

      I created a calculated field as below, but it's not working.

       

      If[Date]>=DATE(7/1/2014)AND [Date]<=DATE(6/30/2015) THEN '2014-2015'

      ELSEIF [Date]>=DATE(7/1/2015) AND [Date]<=DATE(6/30/2016) THEN '2015-2016'

      END