Using excel to calculate next birthday with ease.

[Dr Damilare]

I assume you have your data complete with your dates of birth and your cut-off date.

The key is with the respective months as against the month on your cut of date. It will therefore be best to us 'text to columns' to seperate the months and have it in a column.

You can the have your solution thus:

Column A Column B Cloumn C Column D Column E

Birth date Cut-off date Birth month Cut-off month Your solution

05/17/1965 09/23/2015 05 09 =if(Column C<=ColumnD,[Column B - Column A]+1,[Column B - Column A])

This will work all the time.

Cheers!

 

[Special-K99]

Are you trying to solve someone else's problem?
If so you should post a reply to their problem not post a completely new thread.