If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
dates, 1st of month
in cell A1 i have 1-jan-2005. i would like to copy this info down into A2,
A3, A4, etc. as long as i like but each cell should read the next month 1st day. example: A1 = 1-jan-2005 A2 = 1-feb-2005 A3 = 1-mar-2005 etc. what formula do i put in A2 and copy it down such each cell below A2 will come out with the 1st of the month and change years when necessary? please help. |
#2
|
|||
|
|||
Put
1-feb-2005 in A2, then select A1:A2 and drag the fill handle down as far as necessary. If you must have a function, one way: =DATE(YEAR(A1),MONTH(A1)+1,1) In article , "LatinViolin" wrote: in cell A1 i have 1-jan-2005. i would like to copy this info down into A2, A3, A4, etc. as long as i like but each cell should read the next month 1st day. example: A1 = 1-jan-2005 A2 = 1-feb-2005 A3 = 1-mar-2005 etc. what formula do i put in A2 and copy it down such each cell below A2 will come out with the 1st of the month and change years when necessary? please help. |
#3
|
|||
|
|||
thanks, the pull-down worked, but the formula, which is what i need, gives me
#num!. can you help? "LatinViolin" wrote: in cell A1 i have 1-jan-2005. i would like to copy this info down into A2, A3, A4, etc. as long as i like but each cell should read the next month 1st day. example: A1 = 1-jan-2005 A2 = 1-feb-2005 A3 = 1-mar-2005 etc. what formula do i put in A2 and copy it down such each cell below A2 will come out with the 1st of the month and change years when necessary? please help. |
#4
|
|||
|
|||
Did you put the formula in A2. Is the value in A1 an actual Date value
1-Jan-2005 i.e. if you format A1 as general does it look like: 38353 Actually, the formula works for me even with the string 1-Jan-2005 in A1. If I make A1 blank, I get #Value, not #Num. I can get a #Num if I put a negative number in A1 -- Regards, Tom Ogilvy "LatinViolin" wrote in message ... thanks, the pull-down worked, but the formula, which is what i need, gives me #num!. can you help? "LatinViolin" wrote: in cell A1 i have 1-jan-2005. i would like to copy this info down into A2, A3, A4, etc. as long as i like but each cell should read the next month 1st day. example: A1 = 1-jan-2005 A2 = 1-feb-2005 A3 = 1-mar-2005 etc. what formula do i put in A2 and copy it down such each cell below A2 will come out with the 1st of the month and change years when necessary? please help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
2 Que's regarding dates (matching and subtracting) | jacob farino | General Discussion | 1 | October 11th, 2004 05:11 AM |
Report 1st of the month | Bob Phillips | Worksheet Functions | 1 | June 2nd, 2004 02:28 AM |