Hi
Take a look at the undocumented Datedif function.
Chip Pearson has information on his site
http://www.cpearson.com/Excel/datedif.aspx
--
Regards
Roger Govier

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.