Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill rows with months based on cell value
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill rows with months based on cell value
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)+RO WS($1:1),1)) Copy A3 down to cover the max expected number in A1 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Drew" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill rows with months based on cell value
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" wrote in message ... 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)+RO WS($1:1),1)) Copy A3 down to cover the max expected number in A1 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Drew" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill rows with months based on cell value
Max ... I worked it out ... changing the 1 at end of formula to '0'.
Thank you again very much. "Drew" wrote in message ... 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" wrote in message ... 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)+RO WS($1:1),1)) Copy A3 down to cover the max expected number in A1 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Drew" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill rows with months based on cell value
Adjust it a little
Use instead in A3, copied down: =IF(ROWS($1:1)A$1,"",DATE(YEAR(A$2),MONTH(A$2)+RO WS($1:1)-1,1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Drew" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill rows with months based on cell value
No prob. I posted another way in reply.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Drew" wrote in message ... Max ... I worked it out ... changing the 1 at end of formula to '0'. Thank you again very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto fill rows in Excel 2007 | Excel Discussion (Misc queries) | |||
auto fill columns based on a selection | Excel Discussion (Misc queries) | |||
Auto fill Column based on data in other columns | New Users to Excel | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions | |||
How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) |