WksDateFmtType Values
The WksDateFmtType value is used by the worksheet when a date format is set with the SetDateTimeFmtType method or the DateFmtType property.
| 
                                                     Enumeration  | 
                                                
                                                     Value  | 
                                                
                                                     Display  | 
                                                
                                                     Example  | 
                                                
                                                     Description  | 
                                            
| 
                                                     WksDateFmt_NONE  | 
                                                
                                                     0  | 
                                                
                                                     (None)  | 
                                                
                                                     
  | 
                                                
                                                     Date not displayed  | 
                                            
| 
                                                     WksDateFmt_M_D  | 
                                                
                                                     1  | 
                                                
                                                     m/d  | 
                                                
                                                     9/7  | 
                                                
                                                     Single digit month and day, separated with /  | 
                                            
| 
                                                     WksDateFmt_M_D_YY  | 
                                                
                                                     2  | 
                                                
                                                     m/d/yy  | 
                                                
                                                     9/7/98  | 
                                                
                                                     Single digit month and day, two digit year, separated with /  | 
                                            
| 
                                                     WksDateFmt_MM_DD_YY  | 
                                                
                                                     3  | 
                                                
                                                     mm/dd/yy  | 
                                                
                                                     09/07/98  | 
                                                
                                                     Double digit month, day, and year, separated with /  | 
                                            
| 
                                                     WksDateFmt_D_MON  | 
                                                
                                                     4  | 
                                                
                                                     d-mmm  | 
                                                
                                                     7-Sep  | 
                                                
                                                     Single digit day, shortened month name, separated with -  | 
                                            
| 
                                                     WksDateFmt_D_MON_YY  | 
                                                
                                                     5  | 
                                                
                                                     d-mmm-yy  | 
                                                
                                                     7-Sep-98  | 
                                                
                                                     Single digit day, shortened month name, two digit year, separated with -  | 
                                            
| 
                                                     WksDateFmt_DD_MON_YY  | 
                                                
                                                     6  | 
                                                
                                                     dd-mmm-yy  | 
                                                
                                                     07-Sep-98  | 
                                                
                                                     Double digit day, shortened month name, two digit year, separated with -  | 
                                            
| 
                                                     WksDateFmt_MON_YY  | 
                                                
                                                     7  | 
                                                
                                                     mmm-yy  | 
                                                
                                                     Sep-98  | 
                                                
                                                     Shortened month name, two digit year, separated with -  | 
                                            
| 
                                                     WksDateFmt_MONTH_YY  | 
                                                
                                                     8  | 
                                                
                                                     mmmm-yy  | 
                                                
                                                     September-98  | 
                                                
                                                     Full month name, two digit year, separated with -  | 
                                            
| 
                                                     WksDateFmt_MONTH_D_YYYY  | 
                                                
                                                     9  | 
                                                
                                                     mmmm-d-yyyy  | 
                                                
                                                     September-7-1998  | 
                                                
                                                     Full month name, single digit day, full year, separated with -  | 
                                            
| 
                                                     WksDateFmt_M  | 
                                                
                                                     10  | 
                                                
                                                     mmmmm  | 
                                                
                                                     S  | 
                                                
                                                     First letter of month name  | 
                                            
| 
                                                     WksDateFmt_M_YY  | 
                                                
                                                     11  | 
                                                
                                                     mmmmm-yy  | 
                                                
                                                     S-98  | 
                                                
                                                     First letter of month name, two digit year, separated with -  | 
                                            
| 
                                                     WksDateFmt_M_D_YYYY  | 
                                                
                                                     12  | 
                                                
                                                     m/d/yyyy  | 
                                                
                                                     9/7/1998  | 
                                                
                                                     Single digit month and day, full year, separated with /  | 
                                            
| 
                                                     WksDateFmt_D_MON_YYYY  | 
                                                
                                                     13  | 
                                                
                                                     d-mmm-yyyy  | 
                                                
                                                     7-Sep-1998  | 
                                                
                                                     Single digit day, shortened month name, full year, separated with -  | 
                                            
| 
                                                     WksDateFmt_D_MONTH_YYYY  | 
                                                
                                                     14  | 
                                                
                                                     d mmmm yyyy  | 
                                                
                                                     7 September 1998  | 
                                                
                                                     Single digit day, full month name, full year, separated with spaces  | 
                                            
| 
                                                     WksDateFmt_D_P_M_P_YY  | 
                                                
                                                     15  | 
                                                
                                                     d.m.yy  | 
                                                
                                                     7.9.98  | 
                                                
                                                     Single digit day and month, two digit year, separated with .  | 
                                            
| 
                                                     WksDateFmt_DD_MM_YYYY  | 
                                                
                                                     16  | 
                                                
                                                     dd/mm/yyyy  | 
                                                
                                                     07/09/1998  | 
                                                
                                                     Double digit day and month, full year, separated with /  | 
                                            
| 
                                                     WksDateFmt_DASH_MM_DD_YY  | 
                                                
                                                     17  | 
                                                
                                                     mm-dd-yy  | 
                                                
                                                     09-07-98  | 
                                                
                                                     Double digit month and day, two digit year, separated with -  | 
                                            
| 
                                                     WksDateFmt_MON_D  | 
                                                
                                                     18  | 
                                                
                                                     mmm-d  | 
                                                
                                                     Sep-7  | 
                                                
                                                     Shortened month name, single digit day, separated with -  | 
                                            
| 
                                                     WksDateFmt_MON_DD_YYYY  | 
                                                
                                                     19  | 
                                                
                                                     mmm dd, yyyy  | 
                                                
                                                     Sep 07, 1998  | 
                                                
                                                     Shortened month name, double digit day, full year, separated with spaces and comma  | 
                                            
| 
                                                     WksDateFmt_MONTH_DD_YYYY  | 
                                                
                                                     20  | 
                                                
                                                     mmmm dd, yyyy  | 
                                                
                                                     September 07, 1998  | 
                                                
                                                     Full month name, double digit day, full year, separated with spaces and comma  | 
                                            
| 
                                                     WksDateFmt_MON_YYYY  | 
                                                
                                                     21  | 
                                                
                                                     mmm-yyyy  | 
                                                
                                                     Sep-1998  | 
                                                
                                                     Shortened month name, full year, separated with -  | 
                                            
| 
                                                     WksDateFmt_MONTH_YYYY  | 
                                                
                                                     22  | 
                                                
                                                     mmmm-yyyy  | 
                                                
                                                     September-1998  | 
                                                
                                                     Full month name, full year, separated with -  | 
                                            
| 
                                                     WksDateFmt_YYYY  | 
                                                
                                                     23  | 
                                                
                                                     yyyy  | 
                                                
                                                     1998  | 
                                                
                                                     Full year  | 
                                            
| 
                                                     WksDateFmt_YY  | 
                                                
                                                     24  | 
                                                
                                                     yy  | 
                                                
                                                     98  | 
                                                
                                                     Two digit year  | 
                                            
| 
                                                     WksDateFmt_MONTH  | 
                                                
                                                     25  | 
                                                
                                                     mmmm  | 
                                                
                                                     September  | 
                                                
                                                     Full month name  | 
                                            
| 
                                                     WksDateFmt_MON  | 
                                                
                                                     26  | 
                                                
                                                     mmm  | 
                                                
                                                     Sep  | 
                                                
                                                     Shortened month name  | 
                                            
| 
                                                     WksDateFmt_MM  | 
                                                
                                                     27  | 
                                                
                                                     mm  | 
                                                
                                                     09  | 
                                                
                                                     Double digit month  | 
                                            
| 
                                                     WksDateFmt_MNUM  | 
                                                
                                                     28  | 
                                                
                                                     m  | 
                                                
                                                     9  | 
                                                
                                                     Single digit month  | 
                                            
| 
                                                     WksDateFmt_DD  | 
                                                
                                                     29  | 
                                                
                                                     dd  | 
                                                
                                                     07  | 
                                                
                                                     Double digit day  | 
                                            
| 
                                                     WksDateFmt_DNUM  | 
                                                
                                                     30  | 
                                                
                                                     d  | 
                                                
                                                     7  | 
                                                
                                                     Single digit day  | 
                                            
| 
                                                     WksDateFmt_DAYOFWEEK  | 
                                                
                                                     31  | 
                                                
                                                     dddd  | 
                                                
                                                     Monday  | 
                                                
                                                     Full day of week name  | 
                                            
| 
                                                     WksDateFmt_DOW  | 
                                                
                                                     32  | 
                                                
                                                     ddd  | 
                                                
                                                     Mon  | 
                                                
                                                     Shortened day of week name  | 
                                            
| 
                                                     WksDateFmt_YY_MM_DD  | 
                                                
                                                     33  | 
                                                
                                                     yy/mm/dd  | 
                                                
                                                     98/09/07  | 
                                                
                                                     Two digit year, double digit month and day, separated with /  | 
                                            
| 
                                                     WksDateFmt_DASH_YYYY_MM_DD  | 
                                                
                                                     34  | 
                                                
                                                     yyyy-mm-dd  | 
                                                
                                                     1998-09-07  | 
                                                
                                                     Full year, double digit month and day, separated with -  | 
                                            
| 
                                                     WksDateFmt_SLASH_D_MNUM_YY  | 
                                                
                                                     35  | 
                                                
                                                     d/m/yy  | 
                                                
                                                     7/9/98  | 
                                                
                                                     Single digit day and month, two digit year, separated with /  | 
                                            
| 
                                                     WksDateFmt_SLASH_DD_MM_YY  | 
                                                
                                                     36  | 
                                                
                                                     dd/mm/yy  | 
                                                
                                                     07/09/98  | 
                                                
                                                     Double digit day and month, two digit year, separated with /  | 
                                            
| 
                                                     WksDateFmt_D_P_M_P_YYYY  | 
                                                
                                                     37  | 
                                                
                                                     d.m.yyyy  | 
                                                
                                                     7.9.1998  | 
                                                
                                                     Single digit day and month, four digit year, separated with .  | 
                                            
| 
                                                     WksDateFmt_D_P_MM_P_YY  | 
                                                
                                                     38  | 
                                                
                                                     d.mm.yy  | 
                                                
                                                     7.09.98  | 
                                                
                                                     Single digit day, two digit month and year, separated with .  | 
                                            
| 
                                                     WksDateFmt_D_P_MM_P_YYYY  | 
                                                
                                                     39  | 
                                                
                                                     d.mm.yyyy  | 
                                                
                                                     7.09.1998  | 
                                                
                                                     Single digit day, two digit month, four digit year, separated with .  | 
                                            
| 
                                                     WksDateFmt_D_P_MON_P_YY  | 
                                                
                                                     40  | 
                                                
                                                     d.mmm.yy  | 
                                                
                                                     7.Sep.98  | 
                                                
                                                     Single digit day, shortened month name, two digit year, separated with .  | 
                                            
| 
                                                     WksDateFmt_D_P_MON_P_YYYY  | 
                                                
                                                     41  | 
                                                
                                                     d.mmm.yyyy  | 
                                                
                                                     7.Sep.1998  | 
                                                
                                                     Single digit day, shortened month name, four digit year, separated with .  | 
                                            
| 
                                                     WksDateFmt_YYYY_M_D  | 
                                                
                                                     42  | 
                                                
                                                     yyyy/m/d  | 
                                                
                                                     1998/9/7  | 
                                                
                                                     four digit year, single digit month and day, separated with /  | 
                                            
| 
                                                     WksDateFmt_YYYY_MON_D  | 
                                                
                                                     43  | 
                                                
                                                     yyyy/mmm/d  | 
                                                
                                                     1998/Sep/7  | 
                                                
                                                     four digit year, shortened month name, single digit day, separated with /  | 
                                            
| 
                                                     WksDateFmt_DASH_YYYY_M_D  | 
                                                
                                                     44  | 
                                                
                                                     yyyy-m-d  | 
                                                
                                                     1998-9-7  | 
                                                
                                                     four digit year, single digit month and day, separated with -  | 
                                            
| 
                                                     WksDateFmt_DASH_YYYY_MON_D  | 
                                                
                                                     45  | 
                                                
                                                     yyyy-mmm-d  | 
                                                
                                                     1998-Sep-7  | 
                                                
                                                     four digit year, shortened month name, separated with -  | 
                                            
| 
                                                     WksDateFmt_YYYY_P_M_P_D  | 
                                                
                                                     46  | 
                                                
                                                     yyyy.m.d  | 
                                                
                                                     1998.9.7  | 
                                                
                                                     four digit year, single digit month and day, separated with .  | 
                                            
| 
                                                     WksDateFmt_YYYY_P_MON_P_D  | 
                                                
                                                     47  | 
                                                
                                                     yyyy.mmm.d  | 
                                                
                                                     1998.Sep.7  | 
                                                
                                                     four digit year, shortened month name, single digit day, separated with .  |