Using date from a cell in a formula

[TheGREATrandino]

I want to use the date, stored as a date, in a cell in a formula in another cell.
I have a table with columns Date, Payee, memo, purchases, payments, and so forth.
When I place the cursor in any cell in the table, it uses a sumifs function to sum all purchases with a date equal to the date in the date column. The sumifs command is in a cell outside of the table.
I tried several things. The last was =SUMIFS(tbl_Transactions[Paymennts],tbl_Transactions[Date],"= date(INDIRECT(B&CELL(row),m/d/yy)",tbl_Transactions[Paymennts],"<>Credit Card Payment") which returns 0
I did a similar command for purchase by account with =XLOOKUP(INDIRECT("A"&CELL("row")&""),Tbl_Accounts[ID],Tbl_Accounts[Balance])

44078​

 

[Momentman]

If i understand your formula correctly, does just using

INDIRECT("B" & ROW())

not work for you, without the date prefix and the equal sign and putting in double quotes

 =SUMIFS(tbl_Transactions[Paymennts],tbl_Transactions[Date],INDIRECT("B"&CELL(row)),,tbl_Transactions[Paymennts],"<>Credit Card Payment")

 

[TheGREATrandino]

UPDATE !!!
I place =TEXT((INDIRECT("B"&CELL("row")&"")),"m/d/yy") in a blank cell above the table and it returned the date in column B of the row that the cursor is on, as desired.
I then place it in the sumif command using the function wizard in the criteria section and it worked!!!

=SUMIFS(tbl_Transactions[Purchases],tbl_Transactions[Date],TEXT((INDIRECT("B"&CELL("row")&"")),"m/d/yy"),tbl_Transactions[Memo],"<>Credit Card Pmt")

 

[Momentman]

and INDIRECT("B" & Row()) doesn't return what you need, if you format the cell as Date

 

[TheGREATrandino]

and INDIRECT("B" & Row()) doesn't return what you need, if you format the cell as Date

INDIRECT("B" & Row()) does not work, returns 0
INDIRECT("B"&CELL("row")) <Note the nested CELL function) returns a number which when formatted as a date does return the correct date.
When I use INDIRECT(..... as criteria in the sumifs command it does in fact work.
So............
I do not need to use the text function and the format of the date.
If I want the date from the column on the row where the cursor is don't I need the cells function