Interval in what units?

Days? Months?

See Chip Pearson's site for the undocumented DateDif function.

http://www.cpearson.com/excel/datedif.aspx


Gord Dibben MS Excel MVP

On Thu, 15 Apr 2010 13:59:01 -0700, WilDeliver
wrote:

I need to calculate the interval between a date next year and a person's next
birthday after that. Sorry if this has been answered, but I can't find it.
Many thanks.