IRR & NPV Calculations with Initial/Start Date
I have tried a workaround for IRR, NPV calculations with initial Date i.e. similar to excel in Anaplan. It worked for me and Hoping that it will be helpful for others too
I hope below Screenshots are in-detail to understand the logic.