Calculating eligibility based on date

Hello,
I'm trying to determine when an employee will be eligible for the 401k program. Employees can enroll after "First of the Month Following" 90 days of employment. I was looking to use a function that would allow me to fill out a cell with the exact date.

Example: if John Doe is hired on 3/2/2021, he's eligible to enroll in the 401k program on 6/1/2021. Enrollments can only occur on the First of the Month. I have attached a sample sheet with one desired result.

I searched through the database but could not find relevant with the keywords I used.

Much appreciated!

Try

=IF(DAY(C2+90)=1,C2+90,EOMONTH(C2+90,0)+1)

Thanks John! this works wonders.

I may have another use for this formula. How would I edit it so that I can use it for health benefits instead. For health benefits, the effective date is at the 90th day (not the First of the Month following rule). So health benefits can be effective at any day of the month. How should I change the formula to match this setting instead?

I see your formula and it's completely alien to me

Just add 90 to the "Start Date"

In the earlier formula: Add 90 days to C2 and check if the date is first of the month (DAY) check) : if not, calculate the start at the first of the NEXT month- EMONTH(C2+90,0) is end of the month in which the 90 days occur say 24 July, so we find EOMONTH (July) and add 1 (day) to we get 1st August as the start date.

Hope this helps

Hi John,

Thanks again for taking the time to respond. What if I want to count consecutive days and return that specific date?

Thanks!

Sorry but I don't understand what you mean by "consecutive days" ? by definition adding 90 (or any number) the days are consecutive.