Prev: Running Excel 12.0 Application on Office 2003
Next: Photo in a sheet
From: Bishop on 6 May 2010 14:55
Is there a way I can check to see if a cell value has a date value... in any
format?
From: Rick Rothstein on 6 May 2010 15:06
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" <Bishop(a)discussions.microsoft.com> wrote in message
news:CCB34A4E-EFAD-43DD-A11E-C021A8F359E5(a)microsoft.com...
> Is there a way I can check to see if a cell value has a date value... in
> any
> format?

From: Gary''s Student on 6 May 2010 15:27
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?
From: Rick Rothstein on 6 May 2010 15:45
I thought the OP might want to check Text representations as well.

--
Rick (MVP - Excel)



"Gary''s Student" <GarysStudent(a)discussions.microsoft.com> wrote in message
news:6311C675-02FF-40A0-BD33-00F99F6E7379(a)microsoft.com...
> 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?

From: Gary''s Student on 6 May 2010 17:01
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" <GarysStudent(a)discussions.microsoft.com> wrote in message
> news:6311C675-02FF-40A0-BD33-00F99F6E7379(a)microsoft.com...
> > 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?
>
> .
>
 | 
Pages: 1
Prev: Running Excel 12.0 Application on Office 2003
Next: Photo in a sheet