| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If [something is of the format of.....]
Gentlemen and Ladies,
I'm trying to find the dates in a worksheet. How do I say something like: If Range("J" & ReportRowNum).Value [if of the format "mm/dd/yyyy" then MyDate = Range("J" & ReportRowNum).Value Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If [something is of the format of.....]
How about:
If IsDate(Worksheets("Sheet1").Range("J" & ReportRowNum)) Then ..... IsDate should return true for numbers formated as dates or text strings that could be successfully evaluated as dates. HTH, George Nicholson Remove 'Junk' from return address. wrote in message oups.com... Gentlemen and Ladies, I'm trying to find the dates in a worksheet. How do I say something like: If Range("J" & ReportRowNum).Value [if of the format "mm/dd/yyyy" then MyDate = Range("J" & ReportRowNum).Value Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Linear Mode
