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: firstname.lastname@example.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