2021 Archives by date, by thread · List index

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

```Den mån 5 apr. 2021 kl 03:46 skrev James <bjlockie@lockie.ca>:

```
```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:
=NOW()-DATE(YEAR(NOW());1;1)+1
or
=DATEDIF(DATE(YEAR(NOW());1;1)-1;NOW();"d")
The last one returns an integer. If you want to use the first one to return
an integer, just modify it like this:
=INT(NOW()-DATE(YEAR(NOW());1;1)+1)

Kind regards

Johnny Rosenberg

```
```
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/
```
```
--
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/

```
```
--
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/