| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting date from cell
I have a text in a cell which ends with a date. I would like to extract the
date. I tried the following: Dim ReportDate As Date ReportDate = Range(Right("L3",8)) - 1 but got a type mismatch error. How do I extract the last 8 characters of a cell into a Date variable in VBA? Thanks, Fred |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting date from Date and Time formatted cell | Excel Discussion (Misc queries) | |||
| Extracting Year from date cell | Excel Programming | |||
| Extracting the Day from a date | Excel Discussion (Misc queries) | |||
| Extracting Time from a cell that has both the date and the time | Excel Discussion (Misc queries) | |||
| Extracting the Month from the Date in other cell | Excel Programming | |||
![Fred Smith[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
