Hello, 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. Can this be done? Thank you. -- View this message in context: http://nabble.documentfoundation.org/Can-dates-change-wrt-a-fixed-date-tp4191587.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