Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index




Here's a formula I'm using


=DATEDIF($Begin_Here.$E$76,R4,"d")


The above formulareturns the day
        number of the year where;


$Begin_Here.$E$76     
          $Begin_Here is a sheet and $E$76 is a cell (on that sheet)
          with the date of 12/31/19


Cell R4
          has the date 10 (which is Monday, February 10, 2020)


"d" is
          the interval




It
          would be nice to have a/(forward slash) after the
          day number of the year which is returned by the above formula.


How can
          this be done?




Thank
          you,




Peter


-- 
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.