Re: How do you compute employees' ages in whole numbers as of a specific date?
From: Chip Pearson (chip_at_cpearson.com)
Date: 04/20/04
- Next message: Frank Kabel: "Re: TIme"
- Previous message: Karen: "How do you compute employees' ages in whole numbers as of a specific date?"
- In reply to: Karen: "How do you compute employees' ages in whole numbers as of a specific date?"
- Next in thread: Karen: "Re: How do you compute employees' ages in whole numbers as of a specific date?"
- Reply: Karen: "Re: How do you compute employees' ages in whole numbers as of a specific date?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Apr 2004 15:18:49 -0500
Karen,
You can use the DATEDIF function to do this. E.g.,
=DATEDIF(birth_date,your_date,"y")
See www.cpearson.com/excel/datedif.htm for more information about
the DATEDIF function.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Karen" <anonymous@discussions.microsoft.com> wrote in message news:64DAF424-8EB8-4AA5-BAE6-AEEBB9451A1D@microsoft.com... >
- Next message: Frank Kabel: "Re: TIme"
- Previous message: Karen: "How do you compute employees' ages in whole numbers as of a specific date?"
- In reply to: Karen: "How do you compute employees' ages in whole numbers as of a specific date?"
- Next in thread: Karen: "Re: How do you compute employees' ages in whole numbers as of a specific date?"
- Reply: Karen: "Re: How do you compute employees' ages in whole numbers as of a specific date?"
- Messages sorted by: [ date ] [ thread ]
