| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting DD/MM/YYYY format into text MMYYYY
Hi, Hoping one of you geniuses can help me. I have a column of dates in DD/MM/YYYY format and I want to (in another column) change them to text so I just show MMYYYY. Any ideas? Also, whilst I am here, does anyone know how to count occurrences of a particular date (by month). ie. if I have all the days in 2006 listed in a column, how would I count how many days fall in a particular month? Many thanks in advance, GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=567897 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting DD/MM/YYYY format into text MMYYYY
1.
=TEXT(A1,"MMYYYY") 2. In this example I count the number of days in range A1:A100 that fall within August 2006 =SUMPRODUCT((A1:A100=DATE(2006,8,1))-(A1:A100=DATE(2006,9,1))) "giantwolf" wrote: Hi, Hoping one of you geniuses can help me. I have a column of dates in DD/MM/YYYY format and I want to (in another column) change them to text so I just show MMYYYY. Any ideas? Also, whilst I am here, does anyone know how to count occurrences of a particular date (by month). ie. if I have all the days in 2006 listed in a column, how would I count how many days fall in a particular month? Many thanks in advance, GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=567897 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting DD/MM/YYYY format into text MMYYYY
thanks sloth -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=567897 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting DD/MM/YYYY format into text MMYYYY
=SUMPRODUCT(--(MONTH(A1:A100))=8) for August dates
"Sloth" wrote: 1. =TEXT(A1,"MMYYYY") 2. In this example I count the number of days in range A1:A100 that fall within August 2006 =SUMPRODUCT((A1:A100=DATE(2006,8,1))-(A1:A100=DATE(2006,9,1))) "giantwolf" wrote: Hi, Hoping one of you geniuses can help me. I have a column of dates in DD/MM/YYYY format and I want to (in another column) change them to text so I just show MMYYYY. Any ideas? Also, whilst I am here, does anyone know how to count occurrences of a particular date (by month). ie. if I have all the days in 2006 listed in a column, how would I count how many days fall in a particular month? Many thanks in advance, GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=567897 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to maintain text characters when converting from xls to dbf f. | Excel Discussion (Misc queries) | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
| Converting number or text to a Date Format | New Users to Excel | |||
| How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
| format cells having text | Excel Discussion (Misc queries) | |||
Hybrid Mode
