Re: [libreoffice-users] Calculating the month number

On 2011-05-25 11:37 AM, Michael D. Setzer II wrote:
> 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?

There are no cells being referenced, I'm simply evaluating the CURRENT
date/Month...

Since I want prior years sheets to continue to evaluate positive, this
will work perfectly for me in this case.

> 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