Here's a formula I'm using
=DATEDIF($Begin_Here.$E$76,R4,"d") The above formulareturns the day number of the year where; $Begin_Here.$E$76 $Begin_Here is a sheet and $E$76 is a cell (on that sheet) with the date of 12/31/19 Cell R4 has the date 10 (which is Monday, February 10, 2020) "d" is the interval It would be nice to have a/(forward slash) after the day number of the year which is returned by the above formula. How can this be done? Thank you, Peter -- 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