Hello All ...

I am building a basic contract tracker spreadsheet.

In one cell I enter the start date and another the number of months of the
contract.

Currently I manually enter the first month (formated Mar-08) in the first
row then manually drag-fill it down to fill the corresponding number of
months of contract.

Is there a way to have Excel 2007 automatically fill this column with the
months based on the value of start date and number of months?

Thank you.

Assuming A1 will house the # of months, eg: 3
and A2 contains your 1st-of-month date, eg: 1-Mar-2008, formatted as: mmm-yy
In A3:
=IF(ROWS($1:1)>A$1,"",DATE(YEAR(A$2),MONTH(A$2)+ROWS($1:1),1))
Copy A3 down to cover the max expected number in A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Drew" <(E-Mail Removed)> wrote in message
news:emN$(E-Mail Removed)...
> Hello All ...
>
> I am building a basic contract tracker spreadsheet.
>
> In one cell I enter the start date and another the number of months of the
> contract.
>
> Currently I manually enter the first month (formated Mar-08) in the first
> row then manually drag-fill it down to fill the corresponding number of
> months of contract.
>
> Is there a way to have Excel 2007 automatically fill this column with the
> months based on the value of start date and number of months?
>
> Thank you.
>

Max ... it works a treat thank you ... excepting if I insert 1/3/08 as start
date the first auto complete month reads Apl-08. I need it to be the same
month as the start date month.

"Max" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Assuming A1 will house the # of months, eg: 3
> and A2 contains your 1st-of-month date, eg: 1-Mar-2008, formatted as:
> mmm-yy
> In A3:
> =IF(ROWS($1:1)>A$1,"",DATE(YEAR(A$2),MONTH(A$2)+ROWS($1:1),1))
> Copy A3 down to cover the max expected number in A1
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Drew" <(E-Mail Removed)> wrote in message
> news:emN$(E-Mail Removed)...
>> Hello All ...
>>
>> I am building a basic contract tracker spreadsheet.
>>
>> In one cell I enter the start date and another the number of months of
>> the contract.
>>
>> Currently I manually enter the first month (formated Mar-08) in the first
>> row then manually drag-fill it down to fill the corresponding number of
>> months of contract.
>>
>> Is there a way to have Excel 2007 automatically fill this column with the
>> months based on the value of start date and number of months?
>>
>> Thank you.
>>
>
>

Max ... I worked it out ... changing the 1 at end of formula to '0'.

Thank you again very much.

"Drew" <(E-Mail Removed)> wrote in message
news:e%230a4$(E-Mail Removed)...
> Max ... it works a treat thank you ... excepting if I insert 1/3/08 as
> start date the first auto complete month reads Apl-08. I need it to be the
> same month as the start date month.
>
> "Max" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Assuming A1 will house the # of months, eg: 3
>> and A2 contains your 1st-of-month date, eg: 1-Mar-2008, formatted as:
>> mmm-yy
>> In A3:
>> =IF(ROWS($1:1)>A$1,"",DATE(YEAR(A$2),MONTH(A$2)+ROWS($1:1),1))
>> Copy A3 down to cover the max expected number in A1
>> --
>> Max
>> Singapore
>> http://savefile.com/projects/236895
>> xdemechanik
>> ---
>> "Drew" <(E-Mail Removed)> wrote in message
>> news:emN$(E-Mail Removed)...
>>> Hello All ...
>>>
>>> I am building a basic contract tracker spreadsheet.
>>>
>>> In one cell I enter the start date and another the number of months of
>>> the contract.
>>>
>>> Currently I manually enter the first month (formated Mar-08) in the
>>> first row then manually drag-fill it down to fill the corresponding
>>> number of months of contract.
>>>
>>> Is there a way to have Excel 2007 automatically fill this column with
>>> the months based on the value of start date and number of months?
>>>
>>> Thank you.
>>>
>>
>>
>
>

Adjust it a little
Use instead in A3, copied down:
=IF(ROWS($1:1)>A$1,"",DATE(YEAR(A$2),MONTH(A$2)+ROWS($1:1)-1,1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Drew" <(E-Mail Removed)> wrote in message
news:e%230a4$(E-Mail Removed)...
> Max ... it works a treat thank you ... excepting if I insert 1/3/08 as
> start date the first auto complete month reads Apl-08. I need it to be the
> same month as the start date month.

No prob. I posted another way in reply.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Drew" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Max ... I worked it out ... changing the 1 at end of formula to '0'.
>
> Thank you again very much.