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

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

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