Table Formula Dates

[jstevens]

I'm having a challenge creating a formula referencing a table date field. I'm trying to use Text(Today(),"MMYYYY") in the formula.

I have provided a sample workbook.

EL_table_date.xlsx

Your suggestions are appreciated.

[HansV]

Criteria range arguments of SUMIFS cannot be expressions, they must be ranges. You can use a SUMPRODUCT formula instead:

=SUMPRODUCT(tblDue[Amount],(TEXT(tblDue[Mail_Check],"MMYYYY")=TEXT(TODAY(),"MMYYYY"))*(tblDue[Vendor]=G2))

[jstevens]

Thanks Hans!

[jstevens]

Hans,

If I introduce an additional field column in the table called "Status" between Amount and Mail_Check (3rd Column) I would like to create a INDEX/MATCH formula to the Status field.

I'm having a challenge with this formula: =INDEX(tblDue,MATCH(TEXT(TODAY(),"MMYYYY"),TEXT(tblDue[Mail_Check],"MMYYYY"),0),3)

Thanks for taking a look.

[HansV]

Try confirming the formula with Ctrl+Shift+Enter.

[jstevens]

That would do it.