# Calculate value based on date = date in another cell

#### AMP128

##### New Member
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.
 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>

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### duggie33

##### Board Regular
Hi AMP128,

I made some assumptions since it was not completely clear to me. I am assuming that in Jan-2017 Employee is vested at 25%, in Jun-2017 vested at 50%, Jun-2018 vested at 75%, and Jun-2019 vested at 100%. If that is the case, one possible solution is to use the Match function.

The equation to put in cell I2 would be: =MATCH(J1,\$E\$2:\$H\$2,1)*\$D\$2*\$C\$2

You can copy that equation to the cells to the right of it.

Hope that helps,

Doug

#### duggie33

##### Board Regular
Sorry my ranges of off by one because I copied your data from above to Excel and had an extra column so the updated formula is: =MATCH(I1,\$D\$2:\$G\$2,1)*\$C\$2*\$B\$2

Doug

Thank you!

Replies
3
Views
71
Replies
2
Views
90
Replies
1
Views
213
Replies
2
Views
196
Replies
2
Views
292