Thread: Date Math
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
Microsoft Microsoft is offline
external usenet poster
 
Posts: 1
Default Date Math

Excel 2007

1 have a

start date: 01/01/2009
finish date: 23/06/2010

I want to calculate the length of service between the two dates to the
nearest month, eg (dates abaove) and return a string like so

result = 1 year 6 months

how can I do this?

Thanks

A