View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimmy jimmy is offline
external usenet poster
 
Posts: 59
Default I need to find out the YEAR, MONTH, DAY between two dates

I need to find out the YEAR, MONTH, DAY between two dates. for example:
A1:19/05/05 and A2: 30/06/06. How can I have to difference in year, month,
day.
If 0 year, automatically the result must be run out in month, day and so on.

Please send me the formula.

Thanks