On Sat, 04 Apr 2020 13:45:38 +0100 Brian Barker <b.m.bar...@btinternet.com> wrote:
> At 07:50 04/04/2020 -0400, Peter Dutton wrote: > >Thanks- the "/" works perfectly. > > Good-oh! > > >Nothing's easy in this world. > > Many things are. > > >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")" / " > > I still don't think this is the clearest or best formula for what you > need. (And you've lost the ampersand, though I suspect that's a > "feature" of your mail system.) > > >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. > > It's nothing to do with formatting: it's to do with, er, values. It's > hardly surprising, since - as I made clear - what you have now put in > S4 is not the number 41 but the *string* "41 / ", and that is not a > number. You cannot calculate with strings (unless they happen to > represent numbers in a simple way). What do you expect if you try to > divide "three" by "two"? "one point five"?! > > >Any ideas? > > Yes. Take the concatenated slash off your formula so that it creates > the number 41 in S4, as before. Then use > =S4&" / "&366-S4 > for your result. Or keep the two numbers in separate columns as before, but insert another column just containing '/' in between them. It depends what the result is to be used for. > I trust this helps. > > Brian Barker > > -- 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