Click on the first cell containing the original date (A2).Type: =MONTH, followed by an opening bracket (.Click on a blank cell where you want the month to be displayed (B2).Let’s see how you can extract the month from our sample data: If not, then both these functions will return a #VALUE error. In order for this method to work, the original date (on which you want to operate) must be a valid Excel date. The MONTH and YEAR functions can help you extract just the month or year respectively from a date cell.
You don’t want the date 2/10 to be treated as October, the 2nd instead of February, the 10th! Convert Date to Month and Year using the MONTH and YEAR function So when entering the date, make sure you check the format and enter the date in the correct order.
In still other places like China, Iran, and Korea, the order is completely flipped (yyyy/mm/dd).ĭepending on your computer’s date settings Excel will treat parts of your date differently. In the UK and other countries, dates begin with the day and end with the year (dd/mm/yyyyy). For example, in the US format, dates usually begin with the month and end with the year (mm/dd/yyyy). When working with dates, first and foremost, it is important to recognize the original format your Excel dates are in. We will be converting these dates to month and year in Excel: Throughout this tutorial, we are going to be using the following set of dates. Convert Date to Month and Year using Number Formatting.Convert Date to Month and Year using the TEXT Function.Convert Date to Month and Year using the MONTH and YEAR function.
0 kommentar(er)
