If A1 lists my birthday 07/16/79, what formula can I use to have B1 read the number of days until my birthday?
Everything I have tried has come up with my age, my age but negative, or a number in the thousands.
It's suggested that we use the int function
so I start =int( somewhere in the formula do I put today()-A1/365.25? That's the formula that gives my age. Sigh, I am lost, any help at all will be appreciated!!
2007-02-17 08:49:22 · 4 answers · asked by ericamthompson 1 in Education & Reference ➔ Homework Help
So is there no way to calculate the days until birthday if you enter your birthday with the birth year?
2007-02-17 09:31:58 · update #1
=A1-Today()
Format the cell as a number
Make A1 just Jul-16, no year
2007-02-17 08:58:17 · answer #1 · answered by Pseudo Obscure 6 · 0⤊ 0⤋
e.g. in A1 write your Birth.. 17/09/1979..then in B1 write +today() then the formul.. in C1 =+(B1-A1)/365.25 and thats all, you'll get your age. the format C1 for a simple number and 2 decimals.
2007-02-17 09:03:25 · answer #2 · answered by Ezekiel 1 · 0⤊ 0⤋
if you put your birthday in this year in a1 07/16/07 then change your formula to a1 - today()
2007-02-17 09:05:59 · answer #3 · answered by Barbara H 3 · 0⤊ 0⤋
See this link for instructions: http://office.microsoft.com/en-us/excel/HP030561531033.aspx?pid=CH010005121033
2007-02-17 09:02:50 · answer #4 · answered by copperhead 7 · 0⤊ 0⤋