Home |
Search |
Today's Posts |
#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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Month Year Date Format | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
How can i filter dates based on day of month | Excel Worksheet Functions | |||
Total number of each month in a column of dates | Excel Worksheet Functions |