Brian, The first formula you provided works perfectly.
Thanks, Peter On 12/22/18 8:08 PM, Brian Barker wrote: > 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
