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

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

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

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