=IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))-TODAY()<0,DATE(YEAR(TODAY())+1,MONTH(A1),DAY(A1))-TODAY(),DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))-TODAY())

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ward" wrote in message ...
|I have a list of DOB's in column A. I would like to put a formula in column B
| that would work out how many Day's it is until the next birthday ie.
|
| Column A Column B
|
| 14/04/1981 Days unitl birthday here
| 13/2/1979 Days until birthday here