Hello,
Attached is the sheet I need help on.
We have June year end. I am trying to prepare an option expenses per year. I need to use a formula to allocate expenses per year (Column U to Z) based on the Vesting Commence Date (Column H) and the term (Some are one time, some are 48 months (4 years)). I am able to use a formula for the beginning years, but I can not think of a way that the expenses on the last term and stop onward.
Thanks for the help.
Jackson
Bookmarks