quote:
Originally posted by Ddunk
Type a date in a cell. Select the cell so you have the black box around it. In the bottom right corner of that box there should be a black square. Drag that to whatever length you want.
When you finish dragging it, a new box should be right below the mouse. Click that, and select "Fill Months."
1) You don't need to drag the small black box in the right bottom corner of the black selection rectangle. Simply select a cell, put your mouse over it and drag and drop... Much more convenient.
2) When dragging a date to other cells it isn't the month that increases, but the day
3) I don't see any box below the mouse, let alone a selection with "fill months". This could be that what you described is version dependant and will only work with newer Excell versions.
4) Even if this works, the other cells will not update whenever you update the original cell with a new date.
----------------------------
To add 1 month in a cell (B1), based upon another cell (A1) you use this formula in the cell (B1):
=DATE(YEAR(A1),MONTH(A1)
+1,DAY(A1))
Note that formulas are language specific. In your case it might be that you need to replace the comma delimiter "," with a ";" delimiter and change the formula keywords also. See
this page for many translations of formula keywords.
/ 
On Microsoft Office Excel i know they have the formulas so you can add certain cells together etc, well is there a formula so that you add a date into a cell and then in another cell you place the formula so you add a month onto the date you added into the first cell...do you catch my drift??
