How I convert date formatt of dd/mm/yy to mm/yy (not cell format)

G

Guest

How I convert date formatt of dd/mm/yy to mm/yy (not cell format) ?
I want to use the histogram option from tool menu (add-in) to count the
frequnty of certen evet in time scale of month (event per month), but my
event are per day so I need to "round" them. If I'm using "cell format in
order to display in mm/yyyy format it's still remember the original format of
dd/mm/yy.

Any Ideas ?
 
D

Dav

You would have to convert the dates to the same date in a new column
something like assume date is in a2, you could put in b2

=date(year(a2),month(a2),1) would make all the dates in the same month
the same. You could then copy this formula down

Regards

Dav
 

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

change DD/MM/YY to MM/DD/YY 6
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Change from mm/dd/yy to yy/mm> 3
Date Format Not Responding to MM/DD/YY 2
Convert date to text without changing format dd/mm/yy 3
visual basic user form date format dd/mm/yy not mm/dd/yy 1
dd/mm/yy if i change to some other format 2
Entering date as MM/DD/YY no longer works, why? 1

Top