Forum Discussion
rcortesim
Jan 07, 2022Copper Contributor
Sum two cells by a value per each month in a single cell
I've not yet found an article that sums in a single cell for each month. The only ones I've read put the dates on separate rows, but that isn't what I'm trying to do. Hopefully, there is a formula th...
- Jan 07, 2022
If cell contains user input it is illegal to also have a formula because that would change the input. If the month were derived from a formula, then something of the form
= input + 2*MONTH(TODAY())is possible ('input' here referring to the content of cell A1).
PeterBartholomew1
Jan 07, 2022Silver Contributor
If cell contains user input it is illegal to also have a formula because that would change the input. If the month were derived from a formula, then something of the form
= input + 2*MONTH(TODAY())is possible ('input' here referring to the content of cell A1).