Thread
:
Q: age column
View Single Post
#
2
N Harkawat
Posts: n/a
=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.
Reply With Quote