#MonthandYear #LearnwithPassion #ExcelTipsThis video will helps you to extract month and year form date like, Aug19Date format should be like dd/mmThe syntax of YEAR Function in Excel has only one parameter, ie Serial Number Serial Number This is the value we giving to extract the Year from the date or serial number The return value is always between 1900 and 9999 How to Use YEAR Function in Excel?I use the =Month() formula to obtain the month number, then format the cell with mmmm to show the name, however no matter what my date the month always shows as January I think it gets confused between American and Australian date formats, and converts the month number (say 8) to an American date 8/1/1900, but then the function looks in the
5 Methods Excel Experts Use To Get Extract A Month Name From A Date