Thread: Age Formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Age Formula

Hard to say (which is why I mentioned it to note rather than as an
error). Because months are rather fuzzy concepts, it depends on what you
want.

For example:

Assume the birthday is 31 January 2006.

Does 28 February 2008 result in 2Y 1M 0D, or 2Y 0M 28D?

If it's the former, is 29 February 2008 *also* 2Y 1M 0D?



In article ,
Tendresse wrote:

ummm .. so how do I go around that?

thanks a million for your reply ..