Days until birthday

[Guest]

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

 

[Niek Otten]

=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

|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