Format Dates to Match Dates as Headers in Table

[alexb523]

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

 

[FDibbins]

It has been my experience that when working with dates, it is almost always better to work with actual dates - you can format them to pretty much any way you want. That way, you don't need to mess around with "converting" formulas to change them to text, and then mess around again changing them back to dates

 

[alexb523]

My issue is, unless there is an easy way to get my formula to automatically update, i need my info in a table.

In other words, my table has dates has headers. I need my column date, to match the format of a date in the header of a table. I tried to put a visual below.

The IF function above is just an example. i will be using a INDEX/MATCH formula in the long run.

table one
date
4/1/2017
4/2/2017	Yes
4/3/2017
4/4/2017
4/5/2017
4/6/2017
4/7/2017
4/8/2017
4/9/2017
4/10/2017

<colgroup><col><col></colgroup><tbody>
</tbody>

Table Two
4/1/2017	4/2/2017	4/3/2017	4/4/2017	4/5/2017
info	info	info	info	info
info	info	info	info	info
info	info	info	info	info
info	info	info	info	info
info	info	info	info	info
info	info	info	info	info
info	info	info	info	info
info	info	info	info	info
info	info	info	info	info
info	info	info	info	info

<colgroup><col span="5"></colgroup><tbody>
</tbody>

It has been my experience that when working with dates, it is almost always better to work with actual dates - you can format them to pretty much any way you want. That way, you don't need to mess around with "converting" formulas to change them to text, and then mess around again changing them back to dates

 

[Aladin Akyurek]

@alexb523

able functionality considers date values in the headers not as numbers.

Change

StockFlow[[#Headers],[4/2/2017]]

to:

StockFlow[[#Headers],[4/2/2017]]+0

in the formula.