Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm using =(year(now()-datevalue(d4))-1900)
I enter DOB as text and excel finds age of person if born 1930 or after 1930. But if year of birth is 1929 or earlier get error #num! So is their some way to get around this problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DATEVALUE OF CURRENT DATE | Excel Worksheet Functions |