| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz | Excel Discussion (Misc queries) | |||
| No. of days split into periods | Excel Discussion (Misc queries) | |||
| Calendar Days and Option Buttons | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Linear Mode
