Calculate number of days
in [Functions]
|
Prev: COUNTIF Formula
Next: Word lists
From: Mike H on 23 Apr 2010 17:46 Rick, Is one of the years a leap year? Another reason why this is impossible. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Rick Rothstein" wrote: > That can't be done... the number of days in the month depends on the start > date for the calculation. For example, two months starting January 1st has a > different number of days in it than two months starting on March 1st. > > -- > Rick (MVP - Excel) > > > > "Linda P." <Linda P.(a)discussions.microsoft.com> wrote in message > news:F7398AB5-4FC6-4B24-9EB1-37B93D820932(a)microsoft.com... > > 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. > > . >
From: "David Biddulph" groups [at] on 24 Apr 2010 07:09 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 P.(a)discussions.microsoft.com> wrote in message news:F7398AB5-4FC6-4B24-9EB1-37B93D820932(a)microsoft.com... > 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.
From: Linda P. on 27 Apr 2010 11:29
Thank you Teethless Mama and David Biddulph! Either formula will work for me. "Linda P." wrote: > 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. |