Hi, Le 29/07/2014 17:43, Ian Whitfield a écrit : > I came across a situation today where I need to test text - ie I need to > test for a month's name.
If the referenced cell (say it's A1) contains a month name : =IF(A1="AUG";doYes;doNo) If the referenced cell contains a date formatted to display as a month name (namely "MMMM"), then: =IF(MONTH(A1)=8;doYes;doNo) HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
