title: How to get the Version Number of Microsoft Office from its Build number in Powershell
body: <p>I read on my Windows based systems (via Remote Powershell) what is installed on their computers.<br/> This creates a report. I am having some difficulties looking into the evaluation of the Microsoft Office software.</p>
  <p>It is not hard to get the Office version from registry:</p>
  <pre><code>Get-ItemProperty -Path 'HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration' `
            | Select-Object -ExpandProperty VersionToReport  
  </code></pre>
  <p>This will output to something like <code>16.0.14527.20276</code>.
  It is also not hard to evaluate which main version this is:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">Nr</th>
  <th style="text-align: left;">Office Version</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">11.0</td>
  <td style="text-align: left;">Office 2003</td>
  </tr>
  <tr>
  <td style="text-align: center;">12.0</td>
  <td style="text-align: left;">Office 2007</td>
  </tr>
  <tr>
  <td style="text-align: center;">14.0</td>
  <td style="text-align: left;">Office 2010</td>
  </tr>
  <tr>
  <td style="text-align: center;">15.0</td>
  <td style="text-align: left;">Office 2013</td>
  </tr>
  <tr>
  <td style="text-align: center;">16.0</td>
  <td style="text-align: left;">Office 2016+ (2019 or 2022 or MS365 version)</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>As you can see, the 16.0 version is kind of a collection of all latest Office variants. <br/>As logically as it might be to Microsoft, it is useless for my case.</p>
  <p>The solution lies within the rest of the build number. These numbers specify which version of Office you have. <br/>Clearly we are using Office 365, but I want to know whether they are all up-to-date.</p>
  <p>With the rest of the build number, you can get that finer grain of the version. <br/>You could look them up at this <a href="https://docs.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date#version-history" rel="nofollow noreferrer">Microsoft site</a>. There you can find for instance that Build 14527.20234 is Version 2110.</p>
  <p>Since I am monitoring hundreds of computers, this needs to be automated. <br/>So that everytime Microsoft creates a new version, it gets updated automatically.</p>
  <p>How can I end up with an <strong>up-to-date array with</strong> both the <strong>Build numbers and</strong> the <strong>Version numbers</strong>?</p>