title: how can I set the first week of april for this excel formula? =WEEKNUM(A1)
body: <p>How can I set the first day and week of April for this excel formula?  =WEEKNUM(A1)
  Because =WEEKNUM(A1) only works for January 1 or the first week of January.</p>
  
  <p>Because our company Financial/Fiscal Year starts on April 1st. I need to get the week number of each day in a year and it's corresponding WEEKNUMBER, but the First day should be April 1 and not January 1. I will use this on my Time Dimension worksheet that I will import through ETL(SSIS)</p>
  
  <p>Thanks and Regards,</p>
  
  <p>Beau</p>