title: Excel formula for Financial/Fiscal year July 1st to June 30th
body: <p>Question 1 : How can I set the Month of the Financial/Fiscal Year for this excel formula? 
  If the date is July 1 or July 3, 2005 then the result should be <strong>1</strong>. If the date is August 5, 2005 then the result should be <strong>2</strong>. If the date is January 13, 2006 then the result should be <strong>7</strong>. Because our Financial/Fiscal year starts from July 1 and ends on June 30th. Example would be July 1, 2005 to June 30, 2006.</p>
  
  <p>This is the formula that I have but it only applies for January 1, I need a formula that starts on the 1st of July.</p>
  
  <pre><code>=MONTH(A1-(1+ DATE(YEAR(A1),6,31)-DATE(YEAR(A1),1,1)))
  </code></pre>
  
  <p>Because our company Financial/Fiscal Year starts on July 1st. I need to get the month number of each day in a year and it's corresponding MONTH NUMBER, but the First day should be July 1st and not January 1. </p>
  
  <hr>
  
  <p>Question 2 :  How can I set the Quarter of the Financial/Fiscal Year for this excel formula? The First day should be July 1st and not January 1. 
  The result should be like this, if the date is July 1, 2005 then the output should be <strong>Q1,2005</strong>. If the date is January 11, 2006 then the output should be <strong>Q3,2005</strong> and not <strong>Q3, 2006</strong>. The excel formula below is what I have, but it is only good for January 1st and not July 1st.</p>
  
  <pre><code>="Q"&amp;LOOKUP(MONTH(A4),{1,4,7,10},{1,2,3,4})&amp;", "&amp;TEXT(A4,"yyyy")
  </code></pre>
  
  <hr>
  
  <p>Question 3 : How can I set the Financial Half Year of Year?</p>
  
  <p>If the date in Cell A1 is between July 1, 2005 to July 31, 2005 then the output on Cell B2 should be <strong>Jul to Dec 2005</strong>, same with the other dates such as January 1st to January 31, 2008 then output should be <strong>Jan to Jun 2008</strong>. Cell A1 is where I put the dates from July 1, 2005 up to December 31, 2025.</p>
  
  <p>Many Thanks!!</p>
  
  <p>Beau</p>