Jan 07 2022 10:55 AM
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 that will enable this...
I have a cell with a value of 17, let's say that is in A1.
In A2, I want to test for the current month and give it a value, e.g., Jan is 2, Feb is 4, Mar is 6, etc.
Then, in A2, I want to sum the current months value + 17 (value in A1).
Like I mentioned, I've had a hard time finding this formula, as all I've seen puts a date on multiple rows.
Thanks in advance!
Jan 07 2022 11:19 AM
That doesn't work, you need another cell(s) of formulae which defines values for months, with that sum it with A1 placing result in A2.
Jan 07 2022 11:52 AM
Jan 07 2022 11:55 AM
SolutionIf 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).
Jan 07 2022 11:56 AM
Jan 07 2022 11:56 AM
Jan 07 2022 11:58 AM
Jan 07 2022 12:07 PM
Jan 07 2022 12:17 PM
Jan 07 2022 12:22 PM
Jan 07 2022 11:55 AM
SolutionIf 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).