How to calculate age of a person?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grd - 27 Aug 2007 15:56 GMT

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 to this Message

Bernard Liengme - 27 Aug 2007 18:19 GMT

Visit www.cpearson.com and search for DATEDIFF
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi,
>
[quoted text clipped - 9 lines]
>
> Suzanne

Reply to this Message

Go - 28 Aug 2007 23:50 GMT

That works perfectly now.

Thanks for the help

S

> Visit www.cpearson.com and search for DATEDIFF
> best wishes
[quoted text clipped - 11 lines]
> >
> > Suzanne

Reply to this Message