Forum Discussion
Using dates dynamically
Good Day I hope this email finds you well. I am having issues with a phase in spreadsheet. More specifically minipulating the timeframes/dates on the spreadsheet. The Rule is as follows: ...
Good Afternoon
Thank you for your previous assistance. I have a attached my attempt at using your formula, for some reason my investments are being dispersed in the incorrect months. Kindly see excel sheet attached, I have placed notes in order to provide some guidance.
Could you kindly advise what I am doing incorrectly in my formula.
Your assistance will be appreciated.
Kind REgards,
Carlisle Solomon
CarlisleSol - The formula in H3 is comparing the current date with End date instead of the Start Date.
Check out the attached file with the correction.
Thanks,
Himanshu
http://sipnlearn.in