Populate Dates Based on Year Selected

[kumara_faith]

Hi ,

I have the following table:

Lifetime Planner_v1.0.xlsx
	C	D	E	F	G
2	Date		Start Year	2010	17/10/2010
3	17/10/2010		End Year	2011	30/10/2021
4	18/10/2021
5	19/10/2021
6	20/10/2021
7	21/10/2021
8	22/10/2021
9	23/10/2011
10	24/10/2021
11	25/10/2021
12	26/10/2021
13	27/10/2019
14	28/10/2021
15	29/10/2021
16	30/10/2021
Sheet1

The data table is in column C

I am trying to build a formula so that when I choose the start year and end year in cell F2 and F3, the formula will populate the first date for the start year and the last date for the end year.

In the above example, the first date for the start year is 17/10/2010 and the end date for the end year is 30/10/2021.

Is this possible ?

Thank you in advance for all the help.

 

[Peter_SSs]

.. the end date for the end year is 30/10/2021.

That does not look correct to me since your end year is 2011. Try these

21 10 17.xlsm
	C	D	E	F	G
2	Date		Start Year	2010	17/10/2010
3	17/10/2010		End Year	2011	23/10/2011
4	18/10/2021
5	19/10/2021
6	20/10/2021
7	21/10/2021
8	22/10/2021
9	23/10/2011
10	24/10/2021
11	25/10/2021
12	26/10/2021
13	27/10/2019
14	28/10/2021
15	29/10/2021
16	30/10/2021
Dates

Cell Formulas
Range	Formula
G2	G2	=AGGREGATE(15,6,C3:C16/(YEAR(C3:C16)=F2),1)
G3	G3	=AGGREGATE(14,6,C3:C16/(YEAR(C3:C16)=F3),1)

 

[kumara_faith]

Hi Peter,

That worked. Thank you for your valuable time and patience. Appreciate it and have a great day ahead.

 

[Peter_SSs]

You're welcome.