Calendar Formula- Date given/add 90 days/ defult - 1st day next month

Hi (I so appreciate having a place to get help.) I'm working on a deadline and I need to save time by using a formula. I work in HR and I have employees who get benefits after 90 days.

How do I enter?

Date + 90 days = ________

Date (if it falls on a date in the middle of the month) want it to show the first day of the following month =


Thank you in advance
GG

Try

=EOMONTH(A1+90,0)+1

Wait, what do you mean by (if it falls on a date in the middle of the month) ?
Is that pretty much any Day other than the 1st ?
so if it falls on the 2nd, it should then go to the 1st of the next month?

If that was what you mean, then this is probably more accurate
=DATE(YEAR(A1+90),MONTH(A1+90)+(DAY(A1+90)<>1),1)

Thank YOU ! I finished my reports because of your quick response. Now I may have time to read question and replies.

GG