| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell date value
OK,
this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell date value
Greg,
Try this Mydate = Format(Range("start_date"), "dd/mm/yyyy") Mike "greg" wrote: OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell date value
Try
=Format(range("start_Date"),"dd-mm-yyyy") If this post helps click Yes --------------- Jacob Skaria "greg" wrote: OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell date value
thanks all
"Jacob Skaria" wrote in message ... Try =Format(range("start_Date"),"dd-mm-yyyy") If this post helps click Yes --------------- Jacob Skaria "greg" wrote: OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell date value
Why are you using Value2? Try using this...
Range("Start_Date").Value Or, you can format the date value from Value2 yourself.... Format(Range("Start_Date").Value2, "m/d/yyyy") -- Rick (MVP - Excel) "greg" wrote in message ... OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| comparing abr. Date Text cell to a date formatted cell | Excel Programming | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
Hybrid Mode
