Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I convert date formatt of dd/mm/yy to mm/yy (not cell format)
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I convert date formatt of dd/mm/yy to mm/yy (not cell format)
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 -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=522521 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Cell Date / Currency Convert | Excel Discussion (Misc queries) | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) |