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.
Yes: excise that superfluous equals sign.Brian Barker