Re: [libreoffice-users] WEEKNUM_ADD(<ref>;2)

At 14:06 11/02/2014 -0800, James E Lang wrote:
> I am not literate with regard to Excel. I understand that 
> WEEKNUM_ADD() in Calc returns the same value as WEEKNUM() does in 
> the non standards compliant Excel. Under what condition does that 
> value differ from what WEEKNUM() returns in Calc?

The explanations don't really tell me enough, so I suspect the way 
forward with this is simply to test the two functions side by 
side.  This is what testing suggests to me:

As you say, WEEKNUM() follows the standard.  In this case, a week 
belongs to the year in which most (four or more) of its days lie.  So 
week one of any year can start as early as 29 December of the 
previous year or as late as 4 January.  There are 52 or 53 weeks in 
each year.  All weeks except the last have seven days.  (That may 
seem obvious, but read on!)

WEEKNUM_ADD() starts a new week - week one, of course - on 1 January, 
but this is in general a short week, even as short as one day, as it 
ends on the appropriate Saturday or Sunday.  Counted this way, there 
are 53 or 54 weeks in each year, and weeks at both ends of the year 
can be short.

But this doesn't just affect days at the change of year: because of 
these differences, week numbers may be out of step throughout the 
year.  Note also that selecting different values for the second 
parameter - choosing your week to start on Sunday or Monday - will, 
in the case of WEEKNUM(), sometimes affect which week is considered 
week one and therefore also the week numbering throughout the year.

> My .ods file includes calls to WEEKNUM() but the file needs to also 
> be saved as an .xls file to be shared with KingSoft Office so I can 
> print to PDF.

Why don't you just export as PDF from LibreOffice and share the PDF?

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted