Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date formatting
Can someone help me with some vba code for the date function?
what i'm trying to accomplish is to convert the string 20050401 to 04/01/2005. The formula =DATE(LEFT(E7,4),MID(E7,5,2),RIGHT(E7,2)) works fine for that. I would like to put it in vba. I've written: Function new_date(last_done_date) As String 'returns New last_done_date new_date = Application.Date(Left(last_done_date, 4), Mid(last_done_date, 5, 2), Right(last_done_date, 2)) End Function But it returns a value error. last_done_date is the range of cells that contain the date string - 20050401 Thanks, Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Date Formatting | Excel Discussion (Misc queries) | |||
Date formatting | Excel Discussion (Misc queries) | |||
Date Colum Date Formatting & Validation | Excel Programming | |||
date formatting | Excel Programming |