Calculating eligibility based on date

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.