Alan

Posts: n/a

Calculating Age of person on admission date

In cell A1 I have the admission date to a longterm care home- eg.
05/30/2001.
In cell B1 I have the birth date - eg. 02/23/1924.

Can some guru give me a calculation to put in cell C1 that will give me
the age (in years) of the individual when they entered as a resident??

Many thanks in advance,
Alan

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
NETWORKDAYS - Multiple Date Selection	Annabelle	Excel Discussion (Misc queries)	3	October 4th 05 07:04 PM
Calculating a Date for the Future	Niki6	Excel Worksheet Functions	4	September 19th 05 11:49 PM
Calculating a date in Excel...	Christine	Excel Worksheet Functions	4	July 6th 05 10:06 PM
Calculating days between current date and a date in future NETWORKDAYS() function	Faheem Khan	Excel Worksheet Functions	2	February 10th 05 07:18 PM
Calculating due date?	Loyalise	Excel Worksheet Functions	2	November 2nd 04 07:38 AM

All times are GMT +1. The time now is 08:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us