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