Posted to microsoft.public.excel.misc

Susan Sia

external usenet poster

Posts: 4

Calculate age

How can I calculate age accurately? If I put in the following two dates and
use the "Callculate the number of years between two dates" function, I get 26
as the answer, whereas the actual age is 25.

13/09/2003
09/04/2009
--
Susan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate time does not calculate	Wanna Learn	Excel Discussion (Misc queries)	4	August 19th 08 12:51 AM
self calculate	ecurb849	Excel Discussion (Misc queries)	8	March 29th 08 08:11 AM
Calculate age	Grd	New Users to Excel	4	February 28th 07 03:53 PM
calculate	Susan	Excel Worksheet Functions	1	January 30th 07 01:21 PM
Calculate Bar.	Rodney	New Users to Excel	2	June 8th 05 02:20 AM

All times are GMT +1. The time now is 12:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us