I use this a lot. Format the column the way you want it. Put a date in the first cell A formula goes in the cell below =A1+1 Fill from that formula down Copy the the entries Paste Special with values into the same area.
Works for me John On 16/07/2015 6:24 AM, Gilles wrote:
Found it: What you type in the cell must match exactly the format chosen in the Format Cells dialog, in the Format section. For instance, if you choose "Fri. 31 Dec. 99", that is exactly what you must type for LO to figure things out. Thanks a lot! -- View this message in context: http://nabble.documentfoundation.org/Calc-Automate-creation-of-series-of-full-date-ie-Day-name-Date-tp4154586p4154589.html Sent from the Users mailing list archive at Nabble.com.
--- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- 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
