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: [email protected] 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
