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.
 

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
IF 1
move fill automatically to another file 1
Month from the date? 5
Please HELP! 1
Excel is seeing the date as dd/mm/yyyy 4
characters which are matching between Data 1 & Data 2 12
vlookup and countif??? 5

Top