Re: [libreoffice-users] Can dates change wrt a fixed date?

At 16:11 23/08/2016 -0700, Oly Conly wrote:
> I have multiple sets of dates (particular format), like this:
> June 24, 2016
> June 24, 2016
> June 24, 2016
> June 24, 2016
> June 24, 2016
> June 24, 2016
>
> June 25, 2016
> June 25, 2016
> June 25, 2016
> June 25, 2016
>
> June 26, 2016
> June 26, 2016
> June 26, 2016
> June 26, 2016
>
> June 28, 2016
> June 28, 2016
> June 28, 2016
> June 28, 2016
>
> etc.
>
> These is no specific pattern. Sometimes the dates are consecutive, 
> sometimes the next date is after leaving out a few dates. Now if I 
> change the first date "June 24, 2016" to "June 26, 2016" I want the 
> other dates to chronologically change too, automatically ("June 27, 
> 2016", "June 28, 2016" and "June 30, 2016" respectively). Basically, 
> can I fix the first date in a sheet and then make the rest of the 
> date sets in relation to the fixed date, so that when the fixed date 
> changes the rest change too accordingly.

Somewhere in the spreadsheet (this could be on another sheet if 
preferred), in an additional cell - say Xn - enter the starting date. 
Instead of "June24, 2016" in your actual column of dates, enter =X$n 
and fill down the six cells. Instead of "June 25,2016", enter =X$n+1. 
And so on. When you want to change the dates, just change the 
starting date in Xn.

I trust this helps.

Brian Barker


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