| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateValue gets wrong date number
Bernie, Patrick
Many thanks for your help. Your "Split" solution looks like it will work and for that I am grateful - but I must admit I find it extremely odd that DateValue would return the correct value when it was used in the immediate window but a different/incorrect value when used within a macro. Can either of you explain the reason for that? Cheers Stuart |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DateValue gets wrong date number
MS is an American company?
:) no offence guys!!! "StuartBisset" wrote in message ... Bernie, Patrick Many thanks for your help. Your "Split" solution looks like it will work and for that I am grateful - but I must admit I find it extremely odd that DateValue would return the correct value when it was used in the immediate window but a different/incorrect value when used within a macro. Can either of you explain the reason for that? Cheers Stuart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATEVALUE, etc. and Australian date format | Excel Worksheet Functions | |||
| conditional formatting on date where today is or = datevalue | Excel Discussion (Misc queries) | |||
| Date Conversion- DATEVALUE- including minutes | Excel Worksheet Functions | |||
| Date-related problems - max and datevalue | Excel Discussion (Misc queries) | |||
| DATEVALUE OF CURRENT DATE | Excel Worksheet Functions | |||
Hybrid Mode
