Hello,
I am having an issue matching dates in a column (in a table) to dates as a headers in a table.
I have come to find, dates as headers are not necessarily meant for a table. But, this is the best set up i can find.
Ultimately, i am trying to do something similar to one of my previous posts, SUMPRODUCT or INDEX/MATCH When Summing for Certain Criteria
However, if I can convert a date correctly in the formula to match a header, i think i will have it figured out.
=IF(TEXT(IMT_2[@[Date '@ LT]],"mm/dd/yyyy")=StockFlow[[#Headers],[4/2/2017]],"Yes","No")
I cannot get my "IMT Date Table" to match the headers in the "StockFlow Table"
Thanks,
AlexB523
I am having an issue matching dates in a column (in a table) to dates as a headers in a table.
I have come to find, dates as headers are not necessarily meant for a table. But, this is the best set up i can find.
Ultimately, i am trying to do something similar to one of my previous posts, SUMPRODUCT or INDEX/MATCH When Summing for Certain Criteria
However, if I can convert a date correctly in the formula to match a header, i think i will have it figured out.
=IF(TEXT(IMT_2[@[Date '@ LT]],"mm/dd/yyyy")=StockFlow[[#Headers],[4/2/2017]],"Yes","No")
I cannot get my "IMT Date Table" to match the headers in the "StockFlow Table"
Thanks,
AlexB523