Working with dates and cycles

[Prish]

Please can someone assist me with some formulas working with dates and yearly cycles.
I need formulas for the cells highlighted in green below based on today's date.

Excel 2013/2016
	C	D	E	F	G
1	Today	05 March 2018
2
3	Start Date	Cycle in years	Current start cycle	Current end cycle	Expiring in
4	01 January 1998	5
5	08 November 2002	2
6	10 February 2013	3
Sheet1

The cycle in years tells you how many years it takes a cycle from the start date.
Eg. Start date = 01 January 1998 - I need to find the current cycle we in which would be 01 January 2014 to 31 December 2018.
Current start cycle will therefore be 01 January 2014 and current end cycle would be 31 December 2018.
Expiring must show the remaining years and months to reach 31 December 2018, in this case = 0 years & 10 months.

Thanks.

 

[hennahairgel]

Formulae as follows:

Cell E4:
=DATE(YEAR(C4)+(ROUNDDOWN(DATEDIF(C4,$D$1,"Y")/D4,0)*D4), MONTH(C4), DAY(C4))

Cell F4:
=DATE(YEAR(C4)+((ROUNDDOWN(DATEDIF(C4,$D$1,"Y")/D4,0)+1)*D4), MONTH(C4), DAY(C4))-1

Cell G4:
=DATEDIF($D$1,F4,"Y") & " years & " & MOD(DATEDIF($D$1,F4,"M"),12) & " months"

Then copy down

 

[Prish]

Brilliant... Thanks a million!