Avatar of Sanjay Gandhi
Sanjay Gandhi
Flag for India

asked on 

Calculate Due Date from Base Date on Annual, Quarterly Basis


I have some (insurance) policy dates starting from back years. Whenever I open my this (attached) file in Excel, it should show me my next due dates, as per Base dates. The Due date has to be calculated as per Annual, Monthly, Quarterly, and half-yearly basis from Base Date.

Attached file will guide more. In case of any query please revert back.

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Sanjay Gandhi

8/22/2022 - Mon