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.

Text formula in excel for month and year. 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. 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. Then drag the fill handle down to the cells that you want to apply this formula and only the month and year.

To get the month name ie. In the Apply Date Formatting dialog box choose the month and year date format Mar-2001 that you want to use. 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.

Excel Dates give more choices. TEXT A2mm - returns a month number with a leading zero as 01 -. Looking for an excel formula that will display 13-Aug and means August of 2013.

Option 1 - Extract with MONTH and YEAR and test with AND Option 2 - force dates to first of month and compare Option 3 - force dates to last of month and compare Option 4 - concatenate year and month and compare Option 5 - concatenate year and month with TEXT and compare. TEXTA2mmm-yyyy into a blank cell besides your data C2 for instance see screenshot. Second is the format text ie.

Extract only month and year from the date with formulas. In the worksheet cell E2 is named date. The same thing is done with the date in cell C6 the month and year are extracted and joined together.

Download the practice worksheet attached below and try them out yourself. Our fiscal year starts in February and ends in January of the following year for example 1-Feb-2017 to 31-Jan-2018 should Fiscal Year 2018 hence 31-Jul-2017 should be in Fiscal Year 2018 your formula computes Fiscal Year 2017. January February March etc from a date as text you can use the TEXT function with a custom number format.