Calculating birth year by subtracting age from date.

[hovicke]

Hi - I am looking for some help on how to calculate birth year given the below data and assuming the data was run on June 1, 2022:

Employee	YOE	Age
A	1	21
B	2	22.4
C	3	25
D	4	25.7
E	5	29

This is just a sample set of data as the actual data file is much larger. My goal is to determine which year the employees were born if the data file was ran on June 1, 2022. I originally just subtracted the 'Age' column from '2022' with the int() function but realized that doesn't take into account the report being run in June. Can anyone help point me in the right direction?

[PaigeMiller]

June is 6/12 = 0.5 years

So subtract the age from 2022.5