Complex formula to calculate an end date with rules - Please HELP!!

nansi

New Member
Joined
Jun 1, 2019
Messages
5
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 : )
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top