| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String as date
I have a 6 character string of numbers in a cell which I would like to
treat as a date, whereas I can add 1 to it in VBA and it would display as the following day, and then assign that value to a variable. For instance, 033109 would turn into 040109 by adding 1 to it in a procedure. Is this possible to do in a macro? Thanks... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Date string to date format | Excel Discussion (Misc queries) | |||
| Search and Collect Date from Cell Containing a String with a Date | Excel Programming | |||
| VBA convert day and date from text string to Excel date | Excel Programming | |||
| changing a string date into a 'date' | Excel Programming | |||
| Converting a string date into a Excel Date | Excel Programming | |||
![Steve[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
