Question with Date Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Date being calculated in one cell (ex. June 11, 2004), and in another cell, I just want to display the month of that date (ex. June). I am using =Month(A1) But it displays January 6, 1900. How can I have it display June

Thanks

Rishi
 
Hi Rishi!

Various ways but the two most common approaches are:

=A1
Format mmmm

Or:

=TEXT(A1,"mmmm")

The first method retains the underlying date in the cell. The second
method returns the month as text.
 
Back
Top