How To Extract Day, Month, Quarter and Year from Date Fields in Microsoft Excel

 

How To Extract Day, Month, Quarter and Year from Date Fields in Microsoft Excel (Video transcript)

Let’s start by extracting the year from this date in this column D. it is simple. =year(and the date cell) press enter. double click to copy all the cell. so we get the year. to get the months we can do it by the month formula. =month(and the date in D2. we get the months. double click to copy. and now we can extract the day of the month in the same fashion. =day(and Cell E2. so we get day of the month. what about if we want to know the quarters in these dates?. we should approach a little bit differently. first let’s insert new column. To solve this we will use the choose function including the month. so insert the choose function

=Choose(month(E2),1,1,1,2,2,2,3,3,3,4,4,4). that is it. double click to copy.How about if the fiscal year start in October for some company. we can modify the formula like this. Choose(Month(E2),2,2,2,3,3,3,4,4,4,1,1,1)

Our last example is we want to combine the Year, Month and Day to for a date entry. We can use the date function. =Date(E2,F2,G2) and press enter. now we get a clean date from these inputs. It is the same with Hire date actually but you got the point.

Add Comment