Re: [libreoffice-users] Calc week number problem

At 19:09 22/12/2018 -0500, Dotty Peter wrote:
> Here's the updated post with attached file ...

The simplest solution is probably my first suggestion: wrapping
=IF(WEEKDAY(Xn)=1; ... ;"")
around your existing formula.

Note that, unlike the author of this spreadsheet, who has chosen the 
tedious job of inserting the week number formula only in those cells 
in which a visible value is needed, you can fill this formula (or any 
of my suggestions) down the relevant columns. They will show a value 
only for Sundays, as you require. In using this technique, you will 
have learned how to use spreadsheets more efficiently than the 
existing document's author.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy