Den mån 5 apr. 2021 kl 03:46 skrev James <bjloc...@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 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: > > > > =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 <bjloc...@lockie.ca> wrote: > >> How do I get the number of days since the beginning of year? > >> > >> > >> -- > >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org[ > users%2bunsubscr...@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+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 archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- 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 archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy