Get instant live expert help on how to extract month and year from date in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How do I extract the month and year froma date and display it in the format mmm-yy?
Solved by C. W. in 13 mins
i want to extract from a date the year and month to be in the format yearly-monthly as a number/date not text
Solved by O. D. in 23 mins
UNABLE TO EXTRACT YEAR FROM DATE USING YAER FUNCTION
Solved by Z. W. in 29 mins
I am trying to figure out how to take a fiscal year field and month field and create a date in xx/xx/xxxx format in Excel.
The fiscal year is October -September. If the month is October November or December, the date will correspond to the previous year of the fiscal year (ie if the month is "October" and the fiscal year is 2010- the date would read "10/1/2009").
Solved by Z. H. in 26 mins
I have one number 181101 - It signifies 18 as YEAR, 11 is the Month (November) and 01 is the batch Number...Excel is extracting Year and Month, as digits, though my requirement is to extract Year as 2018 and Month as Nov. Please help
Solved by I. Y. in 28 mins