Note that if you use the month( ) then it would be any date in which the month is >5, so 6/1 thru 12/31 of any year. Are the cells refereced entered as dates (numeric) or as strings?
On 25 May 2011 at 11:21, Tanstaafl wrote: Date sent: Wed, 25 May 2011 11:21:34 -0400 From: Tanstaafl <tansta...@libertytrek.org> To: users@libreoffice.org Copies to: Manoharan Durga <durgamanoha...@gudalur.net> Subject: Re: [libreoffice-users] Calculating the month number Send reply to: users@libreoffice.org > Duh! I was trying to type the formula manually and forgot the cell > reference... > > Thanks for the gentle use of the cluestick... :) > > On 2011-05-25 10:33 AM, Manoharan Durga wrote: > > It is just =IF(MONTH(cellreference)>5,1000000,0) > > > > replace cellreference with the cell address where May 2011 is stored. > > > > If you want the formula to automatically evaluate it based on today's > > date, then you can make it like below : > > > > =IF(MONTH(TODAY())>5,1000000,0) > > > > Hope this helps > > > > On Wednesday 25 May 2011 07:49 PM, Tanstaafl wrote: > >> Hi all, > >> > >> I'm trying to do a simple calculation: > >> > >> If the current month is May 2011 or later, 1,000,000, otherwise, 0 > >> > >> I tried: > >> > >> =IF(MONTH(>5),1000000,0) > >> > >> Which obviously doesn't work... > >> > >> Is there an easy way to do this? > >> > > > > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI 10793120.868193 | EINSTEIN 5924368.650851 ROSETTA 3179738.194080 | ABC 5978342.567696 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted