Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
VBA: Three Ways to Handle Text in Numeric Fields
Doubles, but No Troubles
Auto-replace Text in Excel Cell with VBA
Parse Phone and Extension with VBA
Validation Harness in Excel VBA