On 22/12/08 2:52 PM, in article , "Ken
Lumley" wrote:

Perhaps a strange type of request however I have a list of 500 birthdates
and I need to calculate 30 days before the next birthday for each and
display that as a date. I'm using excel 2003 for windows and excel 2004 for
mac.

I can calculate the age as at the next birthday in years and of course the
current age. What I can't seem to figure out how to do is calculate the date
of the next birthday.

Any help would be most appreciated.

Thanks

Sorry all, I had a blank moment. The answer is relatively simple for anyone
who may be interested:

=((DATEDIF(F4,TODAY(),"y")+1)*365.25)+F4-30 where F4 contains the date of
birth