I consider myself a pretty advanced Excel user, I've even programmed in VB to create some cool macros, but the following problem stumps me.

I have an internal client who gave me a spreadsheet with over 3,000 employee names and their start and termination dates on it.

She asked me to figure out what the next 15th or end of the month would be after the termination date for the people who are no longer employed. There are hundreds of people so I'm NOT going to do this manually.

Is there a formula you can think of that would do this?

I am drawing a blank!

I'm not very good with calculating dates in Excel!!! PLEASE HELP!