| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to calculate age of a person?
Hi,
I'm struggling to figure this one out. I have a date column and I'd like to be able to calculate the age without doing it in my head. I've tried to do this but am struggling. Any help will greatly appreciated. Thanks Suzanne |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to calculate age of a person?
Visit www.cpearson.com and search for DATEDIFF
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Grd" wrote in message ... Hi, I'm struggling to figure this one out. I have a date column and I'd like to be able to calculate the age without doing it in my head. I've tried to do this but am struggling. Any help will greatly appreciated. Thanks Suzanne |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to calculate age of a person?
That works perfectly now.
Thanks for the help S "Bernard Liengme" wrote: Visit www.cpearson.com and search for DATEDIFF best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Grd" wrote in message ... Hi, I'm struggling to figure this one out. I have a date column and I'd like to be able to calculate the age without doing it in my head. I've tried to do this but am struggling. Any help will greatly appreciated. Thanks Suzanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I calculate the age of a person | Excel Worksheet Functions | |||
| person name smart tag | Excel Discussion (Misc queries) | |||
| Calculate needed gallons of water, based on weight of person | Excel Worksheet Functions | |||
| how do i MAX to display the person who got MAX | Excel Worksheet Functions | |||
| How do I calculate the age of a person? | New Users to Excel | |||
Linear Mode
