Days until birthday
 

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

Days until birthday
 

=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

Days until birthday
 

Hi,
Thank you for your reply, unfortuantly I think I doing some thing wrong.

No matter when the DOB is in Column A the formula always returns 9 days to
go beofore their birthday in column B.



"Niek Otten" wrote:

=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

Days until birthday
 

sorry it does work - just got my copy and paste mixed up

Thanks again

Ward

"Niek Otten" wrote:

=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