Question with Date Function

R

Rishi

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
 
N

Norman Harker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping strings to integers 6
Pivot table 0
Month days over a time period 5
Extract Date from text 2
Display weeks from a Milestone 0
Date formula rounded up 2
Adding variable number of columns 8
Changing contents of cell based on Cell Format 3

Top