Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Q: age column
Hello,
I have a birthday column with YYYYMMDD format and I need to create an age column. How can I do that? Thanks, Jim. |
#2
|
|||
|
|||
=INT((TODAY()-DATE(LEFT(A1,4),MONTH(MID(A1,5,2)),DAY(RIGHT(A1,2) )))/365)
"JIM.H." wrote in message ... Hello, I have a birthday column with YYYYMMDD format and I need to create an age column. How can I do that? Thanks, Jim. |
#3
|
|||
|
|||
That formula will have errors when the date is near a person's birthday due
to leap year issues. Try =DATEDIF(startdate,enddate,"Y") for years See XL help for more information on this formula. HTH PC "N Harkawat" wrote in message ... =INT((TODAY()-DATE(LEFT(A1,4),MONTH(MID(A1,5,2)),DAY(RIGHT(A1,2) )))/365) "JIM.H." wrote in message ... Hello, I have a birthday column with YYYYMMDD format and I need to create an age column. How can I do that? Thanks, Jim. |
#4
|
|||
|
|||
On Fri, 20 May 2005 08:26:02 -0700, JIM.H.
wrote: Hello, I have a birthday column with YYYYMMDD format and I need to create an age column. How can I do that? Thanks, Jim. With your birth date in A1: =DATEDIF(TEXT(A1,"0000\/00\/00"),TODAY(),"y") will give you the age in years. --ron |
#5
|
|||
|
|||
On Fri, 20 May 2005 08:26:02 -0700, JIM.H.
wrote: Hello, I have a birthday column with YYYYMMDD format and I need to create an age column. How can I do that? Thanks, Jim. My previous formula works for US regional settings. I'm not sure about other countries. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions |