| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick and dirty function to test for MM/DD/YYYY value
Looking for a simple function to accept variable COdate and just test to see if it is in MM/DD/YYYY format, give true if it is or false if it is not. Thanks!
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quick and dirty function to test for MM/DD/YYYY value
Hi Matthew,
Am Fri, 3 Jul 2015 06:21:10 -0700 (PDT) schrieb Matthew Dyer: Looking for a simple function to accept variable COdate and just test to see if it is in MM/DD/YYYY format, give true if it is or false if it is not. Thanks! test your CELL function. In system with german language I can use: =CELL("format",A1)="D4" Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quick and dirty function to test for MM/DD/YYYY value
**SOLVED***
sorry folks, I'm still discovering some fun finesse codes in VBA such as the built-in isdate function! accepts an input and gives a true/false return! just what I was looking for! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sheet dirty read and dirty write? | Excel Programming | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| change birthday display from mm/dd/yyyy to HIDE the yyyy? | Excel Worksheet Functions | |||
| opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY | Excel Programming | |||
| Quick n' dirty code to delete rows? | Excel Programming | |||
Linear Mode
