coolkat999
New Member
- Joined
- Dec 28, 2018
- Messages
- 2
Hi
I need some help writing a formula.
I have a table showing dates of birth for employees. I want to be able to show a "yes" in the table if the employee reaches the minimum age in months under each of the years. So for example, the first employee with a dob of 1/2/1960 should only have Yes showing under the date range 1/1/2021 - 31/12/2021 as they will have met the minimum age requirement of 738 months.
However, I only need the "yes" to show once (ie the earliest possible occasion)
Could someone help me write the formula?
<colgroup><col width="87" style="width: 65pt;"><col width="173" style="width: 130pt;"><col width="87" span="5" style="width: 65pt;"></colgroup><tbody>
</tbody>Many thanks
Will
I need some help writing a formula.
I have a table showing dates of birth for employees. I want to be able to show a "yes" in the table if the employee reaches the minimum age in months under each of the years. So for example, the first employee with a dob of 1/2/1960 should only have Yes showing under the date range 1/1/2021 - 31/12/2021 as they will have met the minimum age requirement of 738 months.
However, I only need the "yes" to show once (ie the earliest possible occasion)
Could someone help me write the formula?
From | 01/01/2019 | 01/01/2020 | 01/01/2021 | 01/01/2022 | 01/01/2023 | |
To | 31/12/2019 | 31/12/2020 | 31/12/2021 | 31/12/2022 | 31/12/2023 | |
Required age (months) | 736 | 737 | 738 | 739 | 740 | |
DOB | 01/02/1960 | Yes | ||||
14/08/1958 | Yes | |||||
09/08/1964 |
<colgroup><col width="87" style="width: 65pt;"><col width="173" style="width: 130pt;"><col width="87" span="5" style="width: 65pt;"></colgroup><tbody>
</tbody>
Will