| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
dates formula
Col A is Jan, Col B is Feb, etc. to Dec.
in A2 is 1 Jan in B2 is 1 Feb and so on. I want to drag down from row 2 to 32 but want each month to stop displaying dates when the end of each Month comes. Jan has 31 days and Feb has 28 so Feb will display nothing in the last few cells not start with March. I use =A2+1 in A3 etc. across the top and drag all columns down at one time so I do not have to do each column one at a time. Thanks, JK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
