E ExcelSur Member Mar 5, 2019 #1 Hi, I have a column named DATE and using Power Query I want to create a custom column YEAR using the DATE column. Thanks for your help
Hi, I have a column named DATE and using Power Query I want to create a custom column YEAR using the DATE column. Thanks for your help
AliGW Well-Known Member Mar 5, 2019 #2 Use this for the custom year column: =Date.Year([Date]) where [Date] is your dates column.
GraH - Guido Well-Known Member Mar 5, 2019 #3 From the ribbon, choose the tab Add Column then on the section From Date & Time, from the drop down select Year - Year.
From the ribbon, choose the tab Add Column then on the section From Date & Time, from the drop down select Year - Year.
E ExcelSur Member Mar 5, 2019 #4 AliGW said: Use this for the custom year column: =Date.Year([Date]) where [Date] is your dates column. Click to expand... Thanks AliGW. That worked great. How can I get the Month Name (Jan or January). I was able to get the Month Number by using your formula. Thanks for your help
AliGW said: Use this for the custom year column: =Date.Year([Date]) where [Date] is your dates column. Click to expand... Thanks AliGW. That worked great. How can I get the Month Name (Jan or January). I was able to get the Month Number by using your formula. Thanks for your help
E ExcelSur Member Mar 5, 2019 #5 GraH - Guido said: From the ribbon, choose the tab Add Column then on the section From Date & Time, from the drop down select Year - Year. View attachment 58449 Click to expand... Thanks Grah. That worked. Thanks for your help again
GraH - Guido said: From the ribbon, choose the tab Add Column then on the section From Date & Time, from the drop down select Year - Year. View attachment 58449 Click to expand... Thanks Grah. That worked. Thanks for your help again