Solved the problem. All I had to do was the following;
Format the selected calendar cell as follows; DD (then a bunch of spaces) WW The result returned was the correct calendar date number and the current week of the year. Now all I have to figure out is how the get the day-number-of-the-year in there. Thank you, all, for your efforts. Carl On 07/12/2018 04:12 AM, Brian Barker wrote: > At 19:30 11/07/2018 -0400, Carl Winerich wrote: >> It's back to the same old question; ... > > Indeed so - and the answer is very much the same as on the previous > two occasions you have asked this. > >> In a calendar, how can I put the day's date (number only) and week >> number and day-number-of-the-year in one cell? > > To put multiple items in one cell, you must concatenate the individual > values. You can do this using the CONCATENATE() function: > =CONCATENATE(<one>;<two>;<three>) > or probably more easily using the & operator: > =<one>&<two>&<three> > - where <one>, <two>, and <three> represent your items - references or > formulae. > > Note that you will have to take care of spacing, so you may need > something like > =<one>&" "&<two>&" "&<three> > instead. > > Note that concatenation - expressed either way - both requires and > produces text items. If you pass it numeric values, these are > converted to text automatically on the fly. If you want more control > over exactly how a value is represented, you may want to do the > conversion yourself, using the TEXT() function, which allows you to > specify the format of the converted value. So if you wanted, say, all > your dates to appear as two-digit numbers, so the first of the month > was "01" instead of just "1", your formula might start > =TEXT(<one>;"00")&" "& ... > >> Particularly in cell A5, B5...etc which are all cells that contain >> only the day number of the month. Here's a link to the Calc calendar >> template I'm trying to use- >> https://extensions.libreoffice.org/templates/calendar-creator The >> template is very useful and I don't want to interfere or mess up the >> calendar creation - which it does perfectly. > > You'll have to puzzle out how to derive formulae for the required two > new values for yourself, unless the answers are buried somewhere in > the existing template. The functions WEEKNUM(), WEEKNUMADD(), and > DAYS() may help. You can read the existing formulae in your template > by selecting relevant cells and looking in the Input Line for each, of > course. > > I trust this helps. > > Brian Barker > -- To unsubscribe e-mail to: [email protected] 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
