Help With Excell

Tech questions of any kind can be asked here.
Forum rules
Forum Specific Rules
So you got questions about audio/video? Wanna know how to rip a digital stream? Make an X/S/VCD to play on your DVD player? Maybe rip a video from VHS or TV? Find the answers here.
User avatar
MetDream
Stone Cold Poster
Posts: 6281
Joined: Fri Jan 28, 2005 2:31 am
Location: Ballston Lake, New York
Country: United States

Help With Excell

Post by MetDream »

Anyone know the formula that I would write that would make a person age automatically populate in an age column based off their birth date in a birth date column? Thanks
Image
Top
User avatar
Speed Damage
Phantom Lord
Posts: 938
Joined: Tue Apr 01, 2003 12:30 am
Location: Wisconsin
Country: United States

Re: Help With Excell

Post by Speed Damage »

I was going to try and write one up since I had to work with something similar in my Java program, but that works a little differently, and I found this anyways:

http://www.fontstuff.com/excel/exltut01.htm
Top
User avatar
MetDream
Stone Cold Poster
Posts: 6281
Joined: Fri Jan 28, 2005 2:31 am
Location: Ballston Lake, New York
Country: United States

Re: Help With Excell

Post by MetDream »

Thanks. That worked. I sent that link to the clerical person that was trying to figure it out for me. She came up with the formula: =INT((TODAY()-G15)/365.25) We just have to change the digits after the G to equal the row number for each cell. Tedious and time consuming, but then that is what I have clerical support for!! :P Thanks again.
Image
Top

Return to “MetPage Tech Center”