Hi dear excel community,
I hope you are having a great day so far.
I am reaching out in hope you could help me with something that's probably rather easy for you.
It's about run-rates and calendarization.
For example, (starting of easy)
if I have a contract that starts 01/01/2019 until 31/12/2019 with an amount of 12,000, I would like to see each month Jan - Dec with an amount of 1,000.
Obviously now it can be more difficult, since some contracts start in the middle of the year and maybe end in the middle of the year.
I attached you an excel on how it would look in a perfect world.
I am not using this forum too often, I hope I asked my questions clearly and confirming to all the forum rules
Thanks so much in advance and if you have any questions, please let me know.
Best,
AFGP
Bookmarks