Re: [libreoffice-users] date, day number, week number in one cell

At 09:04 12/07/2018 -0400, Carl Winerich wrote:
> Existing cell (for the month of February) has the following formula;
> =$G30-$H30+$D32+$E32+COLUMN(A5)
>
> That stuff points to various parts of the spreadsheet and returns 
> the correct numeric day number of the month. When I try to concat it 
> with, say, =DAYS then Err:510 appears in the cell.

I'm not surprised: you concatenate references or expressions in a 
formula, not multiple formulae. What's that extra equals sign doing 
there? That's like writing =A1+=B2 instead of =A1+B2.

> Any ideas?

Yes: excise that superfluous equals sign.

Brian Barker 


--
To unsubscribe e-mail to: users+unsubscribe@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