Forum Discussion
Macro that concatenates two cells, references a Date and then copy pastes value into first
Deleted
I added a formula to column L of the data tab to concatenate the month/day for today's month as an example of one way I believe what you're asking can be done.
wow, thanks JMB17 . beautiful formula.
thanks as well mathetes. for this column i'll probably end up keeping the format as '00 - 00' but i can use the knowledge from your formula as well.
now, i wanted to see if it was possible to have a formula that would list out all the dates that fall in the same month as Today. i figure from there i should be able to finish up this section with index/match.
i'm trying to toy around with the below formulas, but i'm getting either #Value, #Calc or #Spill errors.
is this possible, or am i spinning my wheels?
=FILTER(Data!P:P,VALUE(LEFT(Data!M:M,2)=MONTH(TODAY())))
=FILTER(Data!P:P,LEFT(Data!M:M,2)=MONTH(TODAY()))
=FILTER(Data!P:P,MONTH(Data!M:M=MONTH(TODAY())))
Deleted
As I've said before, I'm mystified by how you're approaching this, unable to figure out the goal.
I can, nevertheless, tell you that the SPILL error with FILTER means something is blocking the function from delivering all the results, not that there's something wrong with the formula. After trying to delete rows and columns adjacent to your own formula, I took your formula and copied it over to a new sheet--you can see the result here.
Clearly some more refinement is needed to the criteria to be applied in the FILTER function.
i've attached an updated file.
in the Data sheet, range )32:V33 is what i'm trying to accomplish. it looks like the formulas work on the Data sheet, but they don't work when i try to transfer over onto the Money sheet.
On the Money sheet, i can't get column L to transfer over. the text doesn't appear even those the formulas should be correct
- think i got it. might be moving onto the next month's section
