LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Stephanie
 
Posts: n/a
Default what is the formula to change 08/14/51 into 1951?

can anyone give me the answer to the above? I have an employee census which
I need to figure out the average age of 200 employees. The dates of borth
are shown as month, date and year.................
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Change sheet name in formula kojimm Excel Worksheet Functions 4 July 15th 05 11:43 PM
Search in 2 kolumns and 1 row Lars Pettersson Excel Worksheet Functions 3 June 3rd 05 01:56 PM
how do i copy formula and change worksheet instead of cell dal0506 Excel Worksheet Functions 2 January 21st 05 08:41 PM
Cannot change a formula Richard F Excel Discussion (Misc queries) 1 January 18th 05 01:57 AM
How to use formula auditing to change upper case to Title Case. ScoobeyDoo Excel Worksheet Functions 1 November 19th 04 06:26 PM


All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"