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


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