Re: [libreoffice-users] Re: Calc function to return the daynumber weeknumber of the year

2014-07-20 Thread Tanstaafl
Perfect, thanks Miguel! On 7/19/2014 10:04 AM, m.a.riosv miguelange...@libreoffice.org wrote: For weeks they have been always in LibreOffice: WEEKNUM( ) returns ISO 8601 week numbers. WEEKNUM_ADD( ) returns week number as excel. For days: =DAYS(TODAY();DATE(YEAR(TODAY());1;1)-1) I

[libreoffice-users] Re: Calc function to return the daynumber weeknumber of the year

2014-07-19 Thread m.a.riosv
For weeks they have been always in LibreOffice: WEEKNUM( ) returns ISO 8601 week numbers. WEEKNUM_ADD( ) returns week number as excel. For days: =DAYS(TODAY();DATE(YEAR(TODAY());1;1)-1) I think the best way to find calc functions it's through function wizard:

[libreoffice-users] Re: Calc Function Wizard - IF Result differences

2013-10-21 Thread Tom
Hi :) Uploading files to Nabble is usually easier. Either click on the links in this email, or navigate from LibreOffice.org (errr, or google-it using LibreOffice Nabble (or something) for your search) Just above the space to entire your Message is a row of buttons including one called

[libreoffice-users] Re: Calc function

2012-04-18 Thread Andreas Säger
Am 17.04.2012 19:35, Mike Phelan wrote: I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once a number appears in B4:G11 4 times, it changes color to Red...got that part. Then I want to manually enter

Re: [libreoffice-users] Re: Calc function

2012-04-18 Thread Johnny Rosenberg
Den 18 april 2012 09:47 skrev Andreas Säger ville...@t-online.de: Am 17.04.2012 19:35, Mike Phelan wrote: I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once a number appears in B4:G11 4 times, it

[libreoffice-users] Re: Calc function

2012-04-18 Thread Andreas Säger
Am 18.04.2012 17:56, Johnny Rosenberg wrote: Den 18 april 2012 09:47 skrev Andreas Sägerville...@t-online.de: Am 17.04.2012 19:35, Mike Phelan wrote: I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once