| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking Cell Value for a Date
Is there a way I can check to see if a cell value has a date value... in any
format? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking Cell Value for a Date
Use VB's IsDate function. For example...
If IsDate(Range("A1").Value) Then ' A1 contains something VB can interpret as a date Else ' The contents of A1 does not look like a date to VB End If -- Rick (MVP - Excel) "Bishop" wrote in message ... Is there a way I can check to see if a cell value has a date value... in any format? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking Cell Value for a Date
Any cell with an integer value between 0 and 2958465 can, with proper
formatting, represent a date. -- Gary''s Student - gsnu201002 "Bishop" wrote: Is there a way I can check to see if a cell value has a date value... in any format? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking Cell Value for a Date
I thought the OP might want to check Text representations as well.
-- Rick (MVP - Excel) "Gary''s Student" wrote in message ... Any cell with an integer value between 0 and 2958465 can, with proper formatting, represent a date. -- Gary''s Student - gsnu201002 "Bishop" wrote: Is there a way I can check to see if a cell value has a date value... in any format? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking Cell Value for a Date
You may be right. I didn't think of that.
-- Gary''s Student - gsnu201002 "Rick Rothstein" wrote: I thought the OP might want to check Text representations as well. -- Rick (MVP - Excel) "Gary''s Student" wrote in message ... Any cell with an integer value between 0 and 2958465 can, with proper formatting, represent a date. -- Gary''s Student - gsnu201002 "Bishop" wrote: Is there a way I can check to see if a cell value has a date value... in any format? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Put todays date in a cell by checking a box!! | Excel Discussion (Misc queries) | |||
| Date checking | Excel Programming | |||
| checking what day a date is? | Excel Programming | |||
| Help with Date checking code | Excel Programming | |||
Linear Mode
