| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date with VBA
Hello,
I need to know if it is possible in a VBA macro to do the following: In Worksheet # 1 I have the following text values in rows: K1 30.11.2004 k2 24.12.2004 k3 30.10.2004 k4 25.11.2004 I would like to have a macro that would go through each line and determine the oldest date and copy that date into Worksheet #2 with the format mn-yy. In the example above: it'd be Oct-04 Thanks for any help, JF |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Threaded Mode
