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 +0000, 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? =DAYS(CONCAT(YEAR(TODAY()),"-",MONTH(TODAY()),"-",DAY(TODAY())),CONCAT(YEAR(TODAY())-1,"-12-31"))
I think you have dismantled today's date and then reassembled it. Perhaps, more easily, this? =DAYS(TODAY(),DATE(YEAR(TODAY()),1,1))+1 Or this? =DAYS(TODAY(),YEAR(TODAY())&"-1-1")+1 I trust this helps. Brian Barker -- To unsubscribe e-mail to: [email protected] 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
