If or VLOOKUP
 

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.

If or VLOOKUP
 

Eán;377273 Wrote:
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.If your date was in A1 put this in B1 and drag down =TEXT(A1,"mmmm")


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105582

If or VLOOKUP
 

Eán;377273 Wrote:
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.Sorry if you only want April then use this formula

=IF(TEXT(A3,"mmmm")<"April","",TEXT(A3,"mmmm"))


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105582

If or VLOOKUP
 

With date in A1

=IF(A1,TEXT(A1,"mmmm"),"")

If this post helps click Yes
---------------
Jacob Skaria


"Eán" wrote:

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.

If or VLOOKUP
 

Simon Lloyd;377295 Wrote:
Sorry if you only want April then use this formula

=IF(TEXT(A3,"mmmm")<"April","",TEXT(A3,"mmmm"))Do nt forget, written like this it will only ever show when there is an
April in the cell!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105582