Calculating Age, creating date formulas and drop down lists

[BBAgroup]

Hello,
In the doc attached I have colour coded with what I require:
Orange column - need to be able to choose from a dropdown list (list is in other tab)
Yellow column - Need to automatically populate employee age
Red column - need this to populate 3 months later than their start date
Blue column - same as above but for 12 months

 

[James006]

Hi,
For cell D3

=DATEDIF(C3,TODAY(),"y")

 

[Georgiboy]

Maybe:

Book1
	C	D	E	F	G
2	DOB	Age	Start Date	3 Months	12 Months
3	12/08/1983	39	27/03/2023	27/06/2023	27/03/2024
4	13/08/1983	39	28/03/2023	28/06/2023	28/03/2024
5	14/08/1983	39	29/03/2023	29/06/2023	29/03/2024
6	15/08/1983	39	30/03/2023	30/06/2023	30/03/2024
7	16/08/1983	39	31/03/2023	30/06/2023	31/03/2024
8	17/08/1983	39	01/04/2023	01/07/2023	01/04/2024
9	18/08/1983	39	02/04/2023	02/07/2023	02/04/2024
10	19/08/1983	39	03/04/2023	03/07/2023	03/04/2024
11	20/08/1983	39	04/04/2023	04/07/2023	04/04/2024
12	21/08/1983	39	05/04/2023	05/07/2023	05/04/2024
13	22/08/1983	39	06/04/2023	06/07/2023	06/04/2024
14	23/08/1983	39	07/04/2023	07/07/2023	07/04/2024
15	24/08/1983	39	08/04/2023	08/07/2023	08/04/2024
16	25/08/1982	40	09/04/2023	09/07/2023	09/04/2024
17	26/08/1983	39	10/04/2023	10/07/2023	10/04/2024
Sheet1

Cell Formulas
Range	Formula
D3:D17	D3	=DATEDIF(C3:C17,TODAY(),"y")
F3:F17	F3	=BYROW(E3:E17,LAMBDA(x,EDATE(x,3)))
G3:G17	G3	=BYROW(E3:E17,LAMBDA(x,EDATE(x,12)))
Dynamic array formulas.

 

[BBAgroup]

=BYROW(E3:E17,LAMBDA(x,EDATE(x,12)))

Hi Georgiboy, thanks for your help. I've implemented those formulas and have 2 new issues.
With columns F & G the formula works however when I click the formula bar it is a grey colour and disappears - this has never happened to me? Pictured below
Additionally, the age formula in column D yellow didn't work as you can see. Thank you so much for your help

 

[James006]

Hi,

Just Format your Column D as General ...

 

[James006]

Hi,
With a dynamic array formula, there is a Spill effect ...
And ....only the first cell in the Spill area is editable.
If you select another cell in the spill area, the formula will be visible in the formula bar, but the text is "ghosted", and cannot be changed ...