| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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................. |
|
#2
|
|||
|
|||
|
To just extract the year they were born use =YEAR("08/14/1951")
-- Regards, Dave "Stephanie" wrote: 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................. |
|
#3
|
|||
|
|||
|
Dave: Thanks!!
"David Billigmeier" wrote: To just extract the year they were born use =YEAR("08/14/1951") -- Regards, Dave "Stephanie" wrote: 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................. |
|
#4
|
|||
|
|||
|
I tried that, got the date of 5/14/1905????
"David Billigmeier" wrote: To just extract the year they were born use =YEAR("08/14/1951") -- Regards, Dave "Stephanie" wrote: 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................. |
|
#5
|
|||
|
|||
|
On Wed, 7 Sep 2005 08:51:11 -0700, Stephanie
wrote: I tried that, got the date of 5/14/1905???? "David Billigmeier" wrote: To just extract the year they were born use =YEAR("08/14/1951") -- Regards, Dave "Stephanie" wrote: 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................. Format your cell as General or Number --ron |
|
#6
|
|||
|
|||
|
thanks Ron, that worked. But when I copy the formula down the column, it's
not picking up the new dates of birth, only the original. Tried using F4, but that doesn't work on this formula for some reason.............. any hints? Thanks again "Ron Rosenfeld" wrote: On Wed, 7 Sep 2005 08:51:11 -0700, Stephanie wrote: I tried that, got the date of 5/14/1905???? "David Billigmeier" wrote: To just extract the year they were born use =YEAR("08/14/1951") -- Regards, Dave "Stephanie" wrote: 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................. Format your cell as General or Number --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change sheet name in formula | Excel Worksheet Functions | |||
| Search in 2 kolumns and 1 row | Excel Worksheet Functions | |||
| how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
Linear Mode
