View Single Post
  #7  
Old April 24th, 2010, 12:09 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Calculate number of days

As others have said, it depends on the start date.
If the start date is in A5, the number of days is
=DATE(YEAR(A5)+A1,MONTH(A5)+A2,DAY(A5)+A3)-A5 and format as General or
Number.
--
David Biddulph


"Linda P." Linda wrote in message
...
I am using Excel 2000.
I need help with a formula. In A1 I have # of years, in A2 I have # of
months and in A3 I have # of days. In A4 I want to add A1 through A3 and
show the total as number of days. Thanks for your help.