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 <[email protected]> > To: [email protected] > Copies to: Manoharan Durga > <[email protected]> > Subject: Re: [libreoffice-users] Calculating the month > number > Send reply to: [email protected] > >> 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 [email protected] 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
