Hi,
I have several customer agreements that I want to track in excel.
Example: One agreement is worth 50 000$ in total (10 000$ per year) and is valid for five years (Starts 2021 ends 2026) and second agreement is valid for 5 years, starts 2023 ends 2028, worth 60 000 $ in total.
Now I want to create a table that enters the value per year automatically and stops when the contract ends.
Is this possible without using VBA?
Thanks in advance.
Bookmarks