The Trumps' wedding ceremony and reception were widely covered by the media. Trump wore a $200,000 dress made by John Galliano of the house of Christian Dior. In 2006, Melania gave birth to a son named Barron William Trump. Donald suggested his first name and Melania his middle name. As an infant, Barron reportedly occupied his own floor in the Trumps' apartment in Trump Tower in Manhattan, but often slept in a crib in his parents' bedroom.
Return Month Name. Return Month Name Is there an easy way to return the month name, rather than the month number as produced by this formula =month()? I know that I can set up a table and use a lookup function, but that's burdensome.
What I want to do is make a formula from Cell G3 in Sheet2 that looks at column A in Sheet1 and calculates the number of cells that contain the word January. The cells that contain the name of a month in Sheet1 have the full date (ie. January 1, 2012) so I'm hoping to find a formula that recognizes one word within the cell so it can calculate the number of entries in a month. Any help would be appreciated. I'm not overly experienced with Excel formulas lol.