If or VLOOKUP

E

Eán

Hi
I have a coloum of dates dd/mm/yyyy but would like in a separate coloum to
show only the month - how would I write a formula to return "April" for all
dates with 04 in the mm?
Please & thank you.
 
S

Simon Lloyd

Simon said:
Sorry if you only want April then use this formula

=IF(TEXT(A3,"mmmm")<>"April","",TEXT(A3,"mmmm"))Dont forget, written like this it will only ever show when there is an
Click to expand...
April in the cell!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 

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

IF or VLOOKUP - help please ..... 4
VBA - exporting serial letters to single documents 0
Date Format 10
separating date and time 5
move fill automatically to another file 1
Date Formats 4
Delete Text in Multiple Cells 3
Indirect formula errors if file is closed 0

Top