I have a paper which calculate total return including dividend payment. I have data of dividend per share and their announcement date, record date and ex-dividend date for all companies in bse 500. But I am confused about on which date i must calculate total return out of these three dates. And only on that date particular day can I calculate total return or adjust it for every day until new dividend announcement is made. Also dividend sheet including final and interim dividend both. So both are considered or not. I am really confused .. please someone help. It's urgent. I am attaching the dividend excel file and formula screenshot from the paper which used total return calculation.