Thread: Difference between dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Difference between dates
You need the DATEDIF function:
http://www.cpearson.com/excel/datedif.htm
--
David Biddulph

"Khurum" wrote in message
...
Hi

I need to work out the difference between todays date and a previous date,
but I want the answer in this format:

Years & Months & Days

Is this possible? I can use today date minus the date and change the
format
to show the difference in days. Any way to then change this to the needed
format?



Reply With QuoteReply With Quote