Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index


You already have the answer, as you have used the YEAR function in your
previous message.
So YEAR(cell) will give you just the year from the date expressed in "cell".
---
Gabriele Ponzo


Il giorno lun 5 apr 2021 alle ore 03:46 James <bjlockie@lockie.ca> ha
scritto:

How do I get the start date to be dynamically the current year?

Apr. 4, 2021 19:30:53 cspiess@ieee.org:

I assume you're asking about how to get the days since the beginning of
the year given an existing date and that you're using LibreOffice Calc.
With this in mind, here is an example:

=DATEDIF("2020-12-31","2021-01-27","d")

The resulting value in the cell will be 27.

The first parameter is the starting date.  Middle parameter is the
current date in question (I used Jan 27th in my example).  The third
parameter is the interval Calc should use, which is days here, hence "d".
Note that if you use 2020-01-01 as the start date, then the 27th day of
January would actually only be the 26th day since Jan 1st, so you need to
use a starting date of the last day of the prior year.

Hope this helps!


On Sun, Apr 4, 2021 at 3:59 PM James <bjlockie@lockie.ca> wrote:
How do I get the number of days since the beginning of year?


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org[
users%2Bunsubscribe@global.libreoffice.org]
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.