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

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 ha scritto: > How do I get the start date to be dynamically

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

Den mån 5 apr. 2021 kl 03:46 skrev James : > How do I get the start date to be dynamically the current year? > Current year: =YEAR(NOW()) First day of current year: =DATE(YEAR(NOW());1;1) Last day of last year: =DATE(YEAR(NOW());1;1)-1 or =DATE(YEAR(NOW())-1;12;31) Days this year so far:

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

At 18:54 04/04/2021 -0400, James Lockie wrote: How do I get the number of days since the beginning of year? At 00:29 05/04/2021 +, James Lockie wrote: How do I get the start date to be dynamically the current year? At 21:04 04/04/2021 -0400, James Lockie wrote: How about this?

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

How do I get the start date to be dynamically the current year? Apr. 4, 2021 19:30:53 cspi...@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:

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., cspi...@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

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

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

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

On Sun, 4 Apr 2021 18:54:28 -0400 James wrote: Hello James, >How do I get the number of days since the beginning of year? Use the DAYS function. See; Note particularly the advice about NOT using

[libreoffice-users] days since beginning of year

How do I get the number of days since the beginning of year? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List