In the example the formula in cell D6 contains this formula.

Text formula in excel for month and year. PIC4 So that is mmyyyy ie. For example you can use the following formula to convert a date in cell A1 to a text string in the traditional US date format monthdayyear. This will cause Excel to display the year and month together but will not change the underlying date.

TEXT A2 m - returns a month number without a leading zero as 1 - 12. See Simple text with day month and year to Excel date conversion if your text dates have all three parts eg 12 05 2012 April 5 2012 yymmdd ddmmyy etc etc. TEXT D823mmmm What youre doing is first changing the date into the month number 10 and then evaluated that as a date which is the 10th of January 1900 and formatting that as mmmm.

Apply the TEXT function to get the year value. Looking for an excel formula that will display 13-Aug and means August of 2013. Excel Dates give more choices.

TEXTThe following formula requires two things first is the value. Extract only month and year from the date with formulas. TEXTA2mmm-yyyy into a blank cell besides your data C2 for instance see screenshot.

Monthday daymonth monthyear etc. If you only want to display a date with the year and month you can simply apply the custom number format yyyymm to the dates. WEEKDAY 562019 Output.

So I did everything as you stated above and changed the Fiscal year starting month to 2 and it does not calculate it right for some dates. The format we want to follow or the format in which we want to convert our format into. 2 The above formula outputs 2 because by default WEEKDAY represents Monday as the integer 2.