| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A better way to get Min and Max date
Using Excel 2000. The below lines are on two rows, I'd like to have as a
few more rows so it's easier to read albeit the _ (space underscore) doesn't like breaking the lines. Is this possible? Also, I don't really like the [65000] in the code but I don't know any other way to get the MIN and MAX dates from a range that charges frequently. The below code places in a file then range values. ActiveCell.FormulaR1C1 = _ "=""Dates: ""&TEXT(MIN(R[3]C:R[65000]C),""dd"")&"" ""&TEXT(MIN(R[3]C:R[65000]C),""mmm"")&"" ""&TEXT(MIN(R[3]C:R[65000]C),""yyyy"")&"" to ""&TEXT(MAX(R[3]C:R[65000]C),""dd"")&"" ""&TEXT(MAX(R[3]C:R[65000]C),""mmm"")&"" ""&TEXT(MAX(R[3]C:R[65000]C),""yyyy"")" Thanks, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| copy date based on date -refer to date range | Excel Programming | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Threaded Mode
