The formula TEXT is being used to get the month name from a date but, in the Russian PC it's not working and not given an error The formula is =TEXT(D7, "mmm") and the result is "mmm" I also tried (The excel way to handle dates in different languages) MONTH () function This function is used to return the month of a date represented by a serial number The month is given as an integer, ranging from 1 (January) to 12 (December) Version Excel 13The VBA MonthName Function returns a string containing the month name, for a supplied month number The syntax of the function is MonthName( Month , Abbreviate )
Excel Get The Day Or Month Name From A Date Projectwoman Com
