To do this you can use any of the following formulas. The Formula for the MONTH Function in Excel is as follows. A positive value for months yields a future date.
As you can see the function returns the same result for the date.
Where the serial number argument is the date that you want to return the month. Create one column header for the day of the month to show the function result in column D. Select a blank cell next to the date you use type this formula DATE YEAR A1MONTH A11DAY A1 and then press Enter key drag fill handle over the cells you need to use this formula. YEAR B2-YEAR A212MONTH B2-MONTH A2 This formula uses the YEAR function which gives you the year number using the date and the MONTH function which gives you the month number using the date.