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/
> > > Privacy Policy: 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

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