[libreoffice-users] [Calc] Automate creation of series of full date (ie. Day name, Date)?
Hello I often use Calc to prepare multi-day trips, and have to write series that look like this: Mon 1 Aug Tue 2 Aug Wed 3 Aug etc. Does Calc come with a way to automate this tedious task, or is there some macro that I could copy/paste from somewhere? Thank you. -- View this message in context: http://nabble.documentfoundation.org/Calc-Automate-creation-of-series-of-full-date-ie-Day-name-Date-tp4154586.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] [Calc] Automate creation of series of full date (ie. Day name, Date)?
On Wed, Jul 15, 2015 at 1:06 PM, Gilles codecompl...@free.fr wrote: Hello I often use Calc to prepare multi-day trips, and have to write series that look like this: Mon 1 Aug Tue 2 Aug Wed 3 Aug etc. You can just enter the first two values (A1 and A2), format them however you want (highlight them, right click - format cell - tab to Number or Format - forget exact wording, set to date and the way you want it to look, exit the dialog, then select A1 and A2 (highlight), select (left click and hold) on the bottom right corner, then just drag it down. It will fill down for you. Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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