How to extract a day, month and year from date fields in Microsoft Excel (Video transcript)
Let’s start by extracting the year from this date in column D. it is simple. =year(and the date cell) press enter. double click to copy all the cells. 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.
Now 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 a day of the month. what about if we want to know the quarters on these dates?. we should approach a little bit differently. first, let’s insert a 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. duble 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 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 the Hire date actually but you got the point.