Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 16 Dec 2018 17:29:04 +0100[SOLVED] Day() doesn't return the correct value. {Oops!
User Error}https://ask.libreoffice.org/en/question/176418/solved-day-doesnt-return-the-correct-value-oops-user-error/I'm currently working in Calc with dates in the 1300s and 1400s. The "Day()" function doesn't work on dates prior to 1582-10-15. For what I'm doing, all I need (RE this issue) is for Day() to return the "day of the month" part of the date; else, I need a reliable way to extract the "day of the month" component from the displayed date.
For my entertainment, I'm using a cell format that shows the date as "YYYY-MM-DD NN"; using the standard ISO8601 format doesn't help. I can change the format to show only the DD component; however, this is useless for my calculations, as the underlying information is unaffected.
An example of the problem involves calculating the years, months and days between two dates; in this case, I end up with a text value automatically displayed in either a "Y-MM-DD", a "YY-MM-DD" or a "YYY-MM-DD" format (with right alignment and a fixed-pitch font, the data presents nicely).
Simply subtracting the smaller date from the larger, and applying a date format, doesn't return the correct answer (a problem with even modern dates, but I'm not dealing with that right now).
I'm using LibreOffice Version: 5.1.6.2 and my OS is Linux Mint 18 "Sarah" with the "Cinnamon" GUI (I hope I expressed that properly).Havaneiss DeiSun, 16 Dec 2018 17:29:04 +0100https://ask.libreoffice.org/en/question/176418/In calc is there a formula to show what day my birthday will be on this year?https://ask.libreoffice.org/en/question/144596/in-calc-is-there-a-formula-to-show-what-day-my-birthday-will-be-on-this-year/ In calc is there a formula to show what day of the week my birthday will be on this year?
And what day of the week I was born on?Mark McLeanWed, 31 Jan 2018 11:07:14 +0100https://ask.libreoffice.org/en/question/144596/Updating days in a series.https://ask.libreoffice.org/en/question/119057/updating-days-in-a-series/For example, if Day Entered in A1 = Monday then update the adjacent cells Tuesday -Sunday and then to Monday again; I can use the fill series to do it as well, but I'm looking for a formula do it for me. inflicteddFri, 04 Aug 2017 21:59:55 +0200https://ask.libreoffice.org/en/question/119057/Function for date to day of weekhttps://ask.libreoffice.org/en/question/59247/function-for-date-to-day-of-week/ Hi,
Is there a function in Calc that I can use to translate a certain date to the day of the week (like Monday, Tuesday, Saturday).
So for 09-10-2015 it will have to give : "Friday"
Thanks for help,
Ruud.
RuudSat, 10 Oct 2015 00:35:05 +0200https://ask.libreoffice.org/en/question/59247/