| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate age from 2 dates in yy,mm,dd format in excel
In excel 2003, how do I claculate age from date of birth and another date. I
would like to express this in yy,mm,dd format (I've already formated the cell to appear this way). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate age from 2 dates in yy,mm,dd format in excel
Try this, with dates in A1 and B1, B1 being the later date (could be
=TODAY() ): =DATEDIF(A1,B1,"y") & "," & DATEDIF(A1,B1,"ym") & "," & DATEDIF(A1,B1,"md") As this returns a string, your cell format is not relevant, though I've tried to match it. Hope this helps. Pete jan wrote: In excel 2003, how do I claculate age from date of birth and another date. I would like to express this in yy,mm,dd format (I've already formated the cell to appear this way). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change format of several dates entered in an Excel column | New Users to Excel | |||
| Format text 'dates' to real dates | Excel Worksheet Functions | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
| how do I get excel to format dates before 1 jan 1900 | Excel Discussion (Misc queries) | |||
Linear Mode
