Related:
- Date to number format using macro
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Spell number in excel without macro - Guide
- Samsung format code - Guide
- How to format hp laptop - Guide
2 responses
See below for a VBA function that converts 3/15/97 into the date number 35504. Of course it can be adapted for any date you have.
Function DateNumber()
Dim MyDate As Date
MyDate = #3/15/1997#
DateNumber = MyDate - #1/1/1900# + 2
MsgBox DateNumber 'Will show 35504
End Function
Function DateNumber()
Dim MyDate As Date
MyDate = #3/15/1997#
DateNumber = MyDate - #1/1/1900# + 2
MsgBox DateNumber 'Will show 35504
End Function
