Hi all,
How do I calculate vested shares, in a particular month, based on the vesting date?
For example, I am trying to solve for Cells I2 and N2, the correct answer will be 25,000, however I don't know how to set up the formula to calculate based on the date in row 1.
D2:G2 are the vesting dates.
<tbody>
</tbody>
How do I calculate vested shares, in a particular month, based on the vesting date?
For example, I am trying to solve for Cells I2 and N2, the correct answer will be 25,000, however I don't know how to set up the formula to calculate based on the date in row 1.
D2:G2 are the vesting dates.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
1 | Name | Amount | Vesting Terms | 1st | 2nd | 3rd | 4th | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | ||
2 | Employee | 100,000 | 25% | Jan-17 | Jun-17 | Jun-18 | Jun-19 | ||||||||
3 | |||||||||||||||
4 |
<tbody>
</tbody>