P
penny
I need a formula that will allow me to calculate how many days to next
birthday.
birthday.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
akphidelt
Use the TODAY() formula
So if you have a birthdate say 06/28/2008 in cell A1
In cell B1 type the formula
=A1-TODAY()
Then make sure you change cell B1s format to General
So if you have a birthdate say 06/28/2008 in cell A1
In cell B1 type the formula
=A1-TODAY()
Then make sure you change cell B1s format to General
A
APS
What if the date of birth is in the past?
For example if the DOB is 1/30 and today is 6/5 then it displays -127. How
do I get it to calculate how many days until 1/30 of next year?
For example if the DOB is 1/30 and today is 6/5 then it displays -127. How
do I get it to calculate how many days until 1/30 of next year?
D
Don Guillett
Wouldn't DOB always be in the past??
Try the DATEDIFF formula
Try the DATEDIFF formula
A
APS
I was referring to the MM/DD portion of the date.
In the previous example I would like it to return 238 or 239 (depending on
Leap Year), instead of -127.
I think I got it, but I don't know how to do it w/o creating column D.
=IF(D2<TODAY(),SUM(D2-(TODAY()-365)),SUM(D2-TODAY()))
Given the following:
D2=this years birthday (ex: DOB=1/30/99, then D3=1/30/08)
---------------------->=DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))
A2=DOB
In the previous example I would like it to return 238 or 239 (depending on
Leap Year), instead of -127.
I think I got it, but I don't know how to do it w/o creating column D.
=IF(D2<TODAY(),SUM(D2-(TODAY()-365)),SUM(D2-TODAY()))
Given the following:
D2=this years birthday (ex: DOB=1/30/99, then D3=1/30/08)
---------------------->=DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))
A2=DOB