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 <codecomplete@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.dev@gmail.com

-- 
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