Hello, I'm having issues with a VLOOKUP formula that tries to fetch the last and first month of a range to calculate annualised return.
I think the issue relies on the date formatting but until now I've failed to fix it, I've tried the text to columns solution, adding the day as well as of course formatting the cells.
I've highlighted in yellow the formula that I'm trying to fix, disregard the ones in red as these will get fixed if I find a solution for the yellow cell.
Since it's too big for the upload option I've included a gdrive link, I hope it's ok: LINK
Thanks,
Dom
I think the issue relies on the date formatting but until now I've failed to fix it, I've tried the text to columns solution, adding the day as well as of course formatting the cells.
I've highlighted in yellow the formula that I'm trying to fix, disregard the ones in red as these will get fixed if I find a solution for the yellow cell.
Since it's too big for the upload option I've included a gdrive link, I hope it's ok: LINK
Thanks,
Dom