| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I automatically calculate ages in Xcel?
I have part of the formula figured out (i THINK) but I'm running into a brink
wall. I figured this would be a popular formula, but apparently it's not. The YEAR funtion doesn't work because it apparently only bases it's output on the date's YEAR...so it doens't understand if the person's birthday hasn't come around yet. HELP PLEASE! |
|
#2
|
|||
|
|||
|
Try
http://www.cpearson.com/excel/datedif.htm Regards, Peo Sjoblom "revkermit" wrote: I have part of the formula figured out (i THINK) but I'm running into a brink wall. I figured this would be a popular formula, but apparently it's not. The YEAR funtion doesn't work because it apparently only bases it's output on the date's YEAR...so it doens't understand if the person's birthday hasn't come around yet. HELP PLEASE! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
| read number/currency automatically | Excel Discussion (Misc queries) | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
| calculate percent increase | Excel Discussion (Misc queries) | |||
Linear Mode
