Can this be done???

G

Guest

As you can see from the sample below, there are multiple instances the same
month name data. What I'd like to do is some how group these into one
instance of each. The column represented here is taken on of a sheet named
"Values" column A1:A1000, which in turn is pulling the date data from off of
a sheet named "DataEntry" column B4:B3000. On the "Values" sheet I want to
only show one instance of the month name. Is this possible to have a function
pull it all together and have a date of 05/01/05 show-up as 'May-05? Yes,
that's correct 'May-05. I do not want 05/01/05 to show up in the formula bar
as a date, I want to see 'May-05 in the formula bar. Is this possible? If it
is how?

May-04
May-04
May-04
June-04
June-04
June-04
July-04
July-04
July-04
July-04
July-04
July-04
July-04
August-04
August-04
August-04
September-04
September-04
September-04
September-04
September-04
 
P

Peo Sjoblom

No it is not possible to format in the formula bar if you have numeric dates
in the cells
 
P

Peo Sjoblom

You can remove the formula bar if you don't want to see the full date


--

Regards,

Peo Sjoblom
 
G

Guest

Thanks, Peo.

Maybe, I am no clear enough. What I'd like to do is find a function that
would convert a date like 05/01/05, 05/01/2005 to something like 'May-05. So
see, I need to the " ' " left of the force the word "May-05" ( to be like
example 'May-05) as a method for forcing the serial date of 05/01/05 to
display as mentioned in the formula bar, instead.

Hope this helps clearify what I'm wondering about! Maybe, it's possible,
maybe it's not! Thanks, for chiming in!
 
P

Peo Sjoblom

=TEXT(A1,"mmmm-yy")

where A1 holds the date, if you copy and paste special as values it will be
displayed as May-05
in the formula bar, if you don't paste special the formula itself will
display in the formula bar


--

Regards,

Peo Sjoblom
 
G

Guest

Thanks again Peo, appreciate the help!

Peo Sjoblom said:
=TEXT(A1,"mmmm-yy")

where A1 holds the date, if you copy and paste special as values it will be
displayed as May-05
in the formula bar, if you don't paste special the formula itself will
display in the formula bar


--

Regards,

Peo Sjoblom
Click to expand...
 

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

rolling time period 4
separating date and time 5
Count months away betwwen a strat and end date by month 1
Sum value between two dates and copy to new cell 6
Count based on multiple criteria 2
Mapping strings to integers 5
Calculating the difference between two dates if two criteria are m 3
Formulas with dates 3

Top