View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default How do I put in a formula in Exel to calculate a persons age?

No

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"CellShocked" <cellshocked@thecellvalueattheendofthespreadsheet. org wrote
in message ...
Do they have any intention of fixing it?



On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur"
wrote:

Hi,

There is a problem with the DATEDIF() with an md. In cell A13, type
31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March
2009. The following formula in Excel 2007, yields -1 (minus 1) as the
answer

=DATEDIF($A13,$B13,"md")

I work around it by using =B13-EDATE(A13,(C13*12)+D13)

C13 has DATEDIF($A13,$B13,"y");
D13 has DATEDIF($A13,$B13,"ym")

Hope this helps.