By default, Excel uses the first day of the month in the date format that contains day as well In case you concatenate day and month fields to get a complete date field, Excel will use the current year in the date by default The order of concatenation is essential for this scenarioThe cell displaying the return may be formatted to display the name of the month instead of a number between 1 and 12 The date in the serial_number argument may be supplied as a serial number, a valid text date (for instance "25Dec01"), as a nested DATE function, or as a nested TODAY functionConvert the month number to month name;
Vba Get Month Name From Date Using Vba Functions Vbaf1 Com
