Hi Guys, I'm new to excel and I took up a time sensitive assignment assignment and I really appreciate any help on this.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Start date (input)[/TD]
[TD]Eligible Months (input)[/TD]
[TD]Age 50 (Input)[/TD]
[TD]Age 55 (input)[/TD]
[TD]Rule62 (input)[/TD]
[TD]Age 62 (Input)[/TD]
[TD]Leave end date[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]06/1/2019[/TD]
[TD]12.5[/TD]
[TD]7/1/2014[/TD]
[TD]07/1/2019[/TD]
[TD]09/1/2019[/TD]
[TD]06/1/2027[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
These are the fields I'm working on..
Leave start date is the output. The conditions for this are - for age 50 and 55, you can take eligible months of leave from the start date. However during this time if you fall under the rule of 62 (like in this case), you will be limited to ONLY 6 months or less from 09/1/2019 (whichever ever comes first). And at age62 leave stops (so in case case where the person reaches age62 date before finishing the eligible months, the leave gets cutoff at that date). With this I have to get the leave end date (output).
I will great appreciate all of your help on this : )
[TABLE="width: 500"]
<tbody>[TR]
[TD]Start date (input)[/TD]
[TD]Eligible Months (input)[/TD]
[TD]Age 50 (Input)[/TD]
[TD]Age 55 (input)[/TD]
[TD]Rule62 (input)[/TD]
[TD]Age 62 (Input)[/TD]
[TD]Leave end date[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]06/1/2019[/TD]
[TD]12.5[/TD]
[TD]7/1/2014[/TD]
[TD]07/1/2019[/TD]
[TD]09/1/2019[/TD]
[TD]06/1/2027[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
These are the fields I'm working on..
Leave start date is the output. The conditions for this are - for age 50 and 55, you can take eligible months of leave from the start date. However during this time if you fall under the rule of 62 (like in this case), you will be limited to ONLY 6 months or less from 09/1/2019 (whichever ever comes first). And at age62 leave stops (so in case case where the person reaches age62 date before finishing the eligible months, the leave gets cutoff at that date). With this I have to get the leave end date (output).
I will great appreciate all of your help on this : )