i want to calculate retirement age of employees from date of birth. I have date of birth of employees. Retirement age is 60 years.
If employees date of birth is after 1 January and before 2 July (i.e 2 January to 1 July) then retirement date will be 30 june 20xx. and if employees date if birth is after 1 july and
before 2 January (i.e. 2 July to 1 January) then the retirement date will be 31 December 20xx.
Kindly help, i have a excel sheet in which i am calculating this data.