Display Age, Cyclically

[mick2]

I am designing a template, where I will enter people’s birthdays.

What formula will return their age(s), last birthday:

• On 1st July each year.
• Continue displaying it, for the next 12 months.
• Repeat this, cyclically.

I am using Excel 2007
Mick2

[daddylonglegs]

So if somebody was born on 10th July 2000 then the formula should show 8 right now (because as of 1st July 2009 age was 8) and will only change to 9 on 1st July 2010?

With DOB in A2 try this formula

=DATEDIF(A2,DATE(YEAR(TODAY()+184)-1,7,1),"y")

[mick2]

Thanks Daddylonglegs, it works like a charm.

Cheers,
Mick2