Calculating the number of months
in [General]
|
From: Philangr8 on 18 May 2010 15:15 I have a column for start date and end date. I would like a formular that tells me how many months it is including the start month and end month. ex. Start date: 11/1/2009 end date: 4/1/2010 this would be 6 months if you include November and April. Thanks in advance
From: FSt1 on 18 May 2010 17:40 hi assuming that start date is in A1 and end date is in b1.... =DATEDIF(A1,B1,"m")+1 regards FSt1 "Philangr8" wrote: > I have a column for start date and end date. I would like a formular that > tells me how many months it is including the start month and end month. > > ex. Start date: 11/1/2009 end date: 4/1/2010 this would be 6 months if you > include November and April. > > Thanks in advance
From: FSt1 on 18 May 2010 17:41 forgot to add format as general regards FSt1 "Philangr8" wrote: > I have a column for start date and end date. I would like a formular that > tells me how many months it is including the start month and end month. > > ex. Start date: 11/1/2009 end date: 4/1/2010 this would be 6 months if you > include November and April. > > Thanks in advance
From: "David Biddulph" groups [at] on 19 May 2010 03:48 Wouldn't that return 1 month if the dates were 20 May and 10 Jun? Doesn't the OP want to include both months? Mightn't he want =DATEDIF(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR(B1),MONTH(B1),1),"m")+1 ? -- David Biddulph "FSt1" <FSt1(a)discussions.microsoft.com> wrote in message news:1121468D-EDD1-4A9F-AF67-83711F034B88(a)microsoft.com... > forgot to add > format as general > > regards > FSt1 > > "Philangr8" wrote: > >> I have a column for start date and end date. I would like a formular that >> tells me how many months it is including the start month and end month. >> >> ex. Start date: 11/1/2009 end date: 4/1/2010 this would be 6 months if >> you >> include November and April. >> >> Thanks in advance
|
Pages: 1 Prev: Shortcut to Convert files to 2007 Next: Can't Save personal.xls When Hidden |