title: Monthly to Daily Value - R
body: <p>I have a data.frame df that has monthly data:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Company</th>
  <th>Store</th>
  <th>Brand</th>
  <th>Month</th>
  <th>Sales</th>
  <th>Budget</th>
  <th>Quantity</th>
  <th>Year</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jun</td>
  <td>$300</td>
  <td>$300</td>
  <td>3000</td>
  <td>2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jul</td>
  <td>$300</td>
  <td>$300</td>
  <td>3000</td>
  <td>2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Aug</td>
  <td>$300</td>
  <td>$300</td>
  <td>3000</td>
  <td>2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Sep</td>
  <td>$300</td>
  <td>$300</td>
  <td>3000</td>
  <td>2022</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want there to be the mean value for every day, for example (Jun has 30 days so, Sales $300 / 30 days = $10 per day):</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Company</th>
  <th>Store</th>
  <th>Brand</th>
  <th>Month</th>
  <th>Sales</th>
  <th>Budget</th>
  <th>Quantity</th>
  <th>Date</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jun</td>
  <td>$10</td>
  <td>$10</td>
  <td>100</td>
  <td>01-06-2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jun</td>
  <td>$10</td>
  <td>$10</td>
  <td>100</td>
  <td>02-06-2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jun</td>
  <td>$10</td>
  <td>$10</td>
  <td>100</td>
  <td>03-06-2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jun</td>
  <td>$10</td>
  <td>$10</td>
  <td>100</td>
  <td>04-06-2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jun</td>
  <td>$10</td>
  <td>$10</td>
  <td>100</td>
  <td>05-06-2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jun</td>
  <td>$10</td>
  <td>$10</td>
  <td>100</td>
  <td>06-06-2022</td>
  </tr>
  <tr>
  <td>A</td>
  <td>Store A</td>
  <td>Brand A</td>
  <td>Jun</td>
  <td>$10</td>
  <td>$10</td>
  <td>100</td>
  <td>07-06-2022</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I dont have any idea what function o code could use for that.</p>
  <p>Thanks!</p>