From: Philangr8 on
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
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
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
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