How about this?
=DAYS(CONCAT(YEAR(TODAY()),"-",MONTH(TODAY()),"-",DAY(TODAY())),CONCAT(YEAR(TODAY())-1,"-12-31"))
On 2021-04-04 7:30 p.m., [email protected] wrote:
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]
<mailto:[email protected]>> wrote:
How do I get the number of days since the beginning of year?
--
To unsubscribe e-mail to: [email protected]
<mailto:users%[email protected]>
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
<https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette
<https://wiki.documentfoundation.org/Netiquette>
List archive: https://listarchives.libreoffice.org/global/users/
<https://listarchives.libreoffice.org/global/users/>
Privacy Policy: https://www.documentfoundation.org/privacy
<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
