title: Excel Calender Template (Weekday)
body: <p>I use Excel 2016. In the template, I found <strong>Academic calender (any year)</strong>. The template is very awesome (for me).
  Then, I try to learn the formula. I found the formula in cell C4 like this:</p>
  
  <pre><code>=Days+1+DATE(Calendar1Year,Calendar1MonthOption,1)-WEEKDAY(DATE(Calendar1Year,Calendar1MonthOption,1),WeekdayOption)
  </code></pre>
  
  <p>I learn the <strong>WeekdayOption</strong> in Weekday function base on combobox in cell B3 (image below)
  <a href="http://i.stack.imgur.com/09FgG.png" rel="nofollow">Question1</a></p>
  
  <p>My question is how WeekdayOption accept word like SUNDAY or MONDAY or TUESDAY or other ? I know it can accept value 11, 12, 13, etc. Can anyone explain how it works or trick to do it ?</p>
  
  <p>The template link is <a href="https://drive.google.com/file/d/0B8LMnzu1UpC-eGxtb2FhMkRROGc/view?usp=sharing" rel="nofollow">here</a> or you can download from excel template.
  Thanks you.</p>