Thanks- the"/" works perfectly.
Nothing's easy in this world.
What has been created in the calc sheet is the day number of
the year which is followed by the "/". In the cell beside the
result is the remaining number of days in the year. Here's an
example of what I'd like to see for this date (February 10,
2020)
41 / 325
In this case 325 is the remaining
number of days in the year 2020 from the date Feb. 10.
The cell in which the formula used to
obtain the figure of 325 is-
=365-S4+1
"S4" is the cell where the day number
of the year is located returned by the formula, as mentioned
below-
=DATEDIF($Begin_Here.$E$76,R4,"d")"
/ "
What happens to the remaining days
number in cell S4 the dreaded error-
#VALUE! is returned.
I suspect this has something to do with
the formatting of the cell but can't figure it out.
Any ideas?
Thanks,
Peter
From:Brian
Barker [mailto:[email protected]]
Subject:[libreoffice-users] Adding a / (forward slash)
Date:Friday,
April 3, 2020, 9:55 PM
To:[email protected]
Cc:Peter
Dutton
At
20:24 03/04/2020 -0400, Peter Dutton wrote:Here's a formula I'm
using=DATEDIF($Begin_Here.$E$76,R4,"d")The above formula returns the day number
of the year where
$Begin_Here.$E$76 [...] the date of 12/31/19Cell R4 has the date 10
(which is Monday, February 10, 2020)"10" is not a date - unless you mean the
date that is internally
stored as the number 10, which would be 9 January 1900! And that
would be an error for the function, since the end date needs to be
later than the start date."d" is the intervalWell, it's the unit in which
you want the returned interval
specified.Wouldn't it be easier to
use=DAYS("2020-02-10";$Begin_Here.$E$76)or
just="2020-02-10"-$Begin_Here.$E$76?Even more easily, abandon your "Begin_Here"
value and try (with
your 10 February 2020 date in R4)=R4-DATE(YEAR(R4)-1;12;31)This will
produce the number 41 - providing the result cell is
appropriately formatted.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?You can concatenate
strings using the "" operator, so just
put"/" after any of these formulae, such
as=R4-DATE(YEAR(R4)-1;12;31)"/"The numerical value 41 is implicitly converted
to a string and
concatenated with the slash to create the *string* 41/ .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
