Sorry I don't know how else to say this. So I am attaching a sheet. I do have some formulas in there now but I have a problem. I have the dates of the enrollments across the top. I have the hire dates. I need to meet with them before 90 days but I want it to be as close to that 90 days as I can get without going over. So if they sent 90 days takes place after the meeting say someone hired on 5/16 I would meet on 7/19 because 8/23 would be after the 90 days. but if they were hired on 5/25 I would meet with them on 8/23. Let me know if that doesn't make sense. Also I would like it to not put an X in the date if I have "Termed" typed in the termed column. Any help or insight would be great.
I know that the current formulas now are not doing what I need because some of my people are over 90 days before meeting. Also, not sure why row 27 and 32 are where they are based on hire date.
Thanks again and ask any questions needed to understand.
Kat
Bookmarks