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