Converting DD/MM/YYYY format into text MMYYYY

G

giantwolf

Hi,

Hoping one of you geniuses can help me. I have a column of dates i
DD/MM/YYYY format and I want to (in another column) change them to tex
so I just show MMYYYY. Any ideas?

Also, whilst I am here, does anyone know how to count occurrences of
particular date (by month). ie. if I have all the days in 2006 liste
in a column, how would I count how many days fall in a particula
month?

Many thanks in advance,

G
 
G

Guest

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)))
 

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

How to convert MM/DD/YYYY to Month 2
Sumproduct and weekday from mm/dd/yyyy format? 3
Changing date to eliminate day in format mm/dd/yyyy 1
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
yyyy-mm-dd date format? 3
change date format from dd/mm/yyyy to mm/yyyy 2
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2

Top