| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
write a formula to calculate age in yrs; 04/30/06 minus birthd
The DATEDIF function is in all versions of Excel, but documented
only in Excel 2000. See www.cpearson.com/excel/datedif.htm for details and documentation. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "BekkiM" wrote in message ... Philip: Where is the "DATEDIF" function? I don't see it my list. Is there an Add-In I'm missing? "Philip J Smith" wrote: Try =datedif(BirthDate,BenchmarkDate,"Y") Regards Phil Smith "yancey04" wrote: I need to write a formula that calculates a childs age as of 04/30/2006 for baseball or as of 01/01/06 for softball. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need help to get formula to calculate royalties recouped with sa | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
| How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
Threaded Mode
