How do I get the start date to be dynamically the current year?
Apr. 4, 2021 19:30:53 [email protected]:
> 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 <[email protected]> wrote:
>> How do I get the number of days since the beginning of year?
>>
>>
>> --
>> To unsubscribe e-mail to:
>> [email protected][users%[email protected]]
>> 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: [email protected]
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
