Help with Dates

The first equation returns a 1. Which is not what I would have expected it to return. I would have expected it to return a 0.

So a follow-up question for you then @Nic Larsen. So the only reason why I'm using these dates is because it's a helper row because based on previous digging, there's currently no formula or expression/function that allows me to use the name of a column in my formula. My goal formula is to leverage two dates in two different columns to return a $ value, how should I then go about doing it? If I turn the whole column into a date column, then it won't return a $ value.

@Nic Larsen. Ok sounds good

So I'll describe it like an XY graph but with rows and columns. So the row is the project and relevant project information. The Y axis (columns) are the weekly dates/benchmarks. Where they meet up will be the $$ values that are calculated for that specific week and for that specific column.

Based on this help forum below, it's determined that I can't utilize a reference to a column name i.e. Column name is "1/25/2025". There's no way for me to reference the name of the column which is 1/25/2025 in my formula within that column. I can refer to the totality of that row and the information within that column but not the column name.

I don't want to transpose the column name data into a column because that would just make the sheet incredibly bulky and hard to parse because that would mean I would have 52 rows for just one project.

Oh weird my comment disappeared.

So I want to reference the column name as a value in the formula... so for example, to return the name of the column if a matching value is found. That's why I have to use a helper column. And I believe if I turn the whole column into dates, I can't return a $$ in my function within that column.