Re: [libreoffice-users] days since beginning of year

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., cspiess@ieee.org 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 <bjlockie@lockie.ca 
> <mailto: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
>     <mailto:users%2Bunsubscribe@global.libreoffice.org>
>     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: 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