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


Am 16.07.2015 um 23:08 schrieb Tom Davies:
Hi :)
If it's spread out into 2 columns (or rows) such that the day-of-the-week
(eg Mon) is in the first cell and then the date part is in the next cell
then both drag down fine.  (I had to set the format of the cell before it
let me show the date in "MMM d" format but that's a side-issue imo).


Like
Sunday 13/7/2015
Monday 14/7/2015
Tuesday 15/7/2015
...

Works perfectly well even though 13/7/15 was a Monday.

You _never_ need to enter any weekday names into a spreadsheet when you
have the dates. This is redundant information which is likely to get out
of sync. A valid date contains the information about the correct weekday
already.

1) Format the dates to show their correct weekdays together with the date.
2) Use a reference to the date cell and format as DDD or DDDD to show
the weekday name in another cell.
3) Use =TEXT(A1;"DDD") to show the weekday name of A1 as a text value.
But do not enter redundant information.


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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.