Next due date in FY 2019-20 based on frequency of payment & start date

[wouldbeca]

I want help with formula for calculating first payment date falling under period 01/04/2019 to 31/03/2020 based on frequency i.e. Annual, Monthly, half Yearly, Quarterly from any date.

e.g.

Start date- 05/08/2012 ( it can range back to year 1950)
Frequency- Half yearly/Quarterly
Result should be- 05/08/2019(half Yearly) & 05/05/2019 (quarterly)


please help

 

[James006]

Hello,

You should use =EDATE()

such as =EDATE(your_date,frequency_in_months)

Hope this will help