Re: [libreoffice-users] Calculating the month number

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 <tanstaafl@libertytrek.org>
To:                     users@libreoffice.org
Copies to:              Manoharan Durga 
<durgamanoharan@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+help@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:mikes@kuentos.guam.net                            
  mailto:msetzerii@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+help@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