Hi community.
Hope you're all safe and well. See below please.
Transaction Date Transaction Type Share Type Ref. No. of Shares Award Share Date Tax Free Date
16-Nov-16 Award Matching Shares 111/1111 5 16/11/2019 16/11/2021
16-Nov-16 Purchase Partnership Shares 111/1112 10 16/11/2019 16/11/2021
This is the setup i have on an excel sheet. What i want to do is calculate the "No. of Shares" dynamically by date. So when they become Tax free i can see the total amount i have available.
Any help is appreciated. Thank you.
T
Bookmarks