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+unsubscr...@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
