I have a pivot table that I am taking data from. Currently, I am able to take data compared to a certain date and display the most recent date's serial number in a separate cell. Now, I want to display that max date instead.
Currently, I use this to pull the most current date completed on an item and display its serial number. A3 is beginning list of items, B1 is the compared date
=MAX(IF((ItemData[Name]=A3)*(ItemData[CompletedDate]<=$B$1),VALUE(ItemData[SerialNumber])),0) array with CTRL + SHIFT + ENTER
Now instead of the serial number, I want to display the actual completed date.
=MAX(IF((ItemData[Name]=A3)*(ItemData[CompletedDate]<=$B$1),VALUE(ItemData[CompletedDate])),0) array with CTRL + SHIFT + ENTER
I receive 1/0/1990.
I tried changing around the format of the date column, but I'm not sure what I am doing wrong to not show more.
Currently, I use this to pull the most current date completed on an item and display its serial number. A3 is beginning list of items, B1 is the compared date
=MAX(IF((ItemData[Name]=A3)*(ItemData[CompletedDate]<=$B$1),VALUE(ItemData[SerialNumber])),0) array with CTRL + SHIFT + ENTER
Now instead of the serial number, I want to display the actual completed date.
=MAX(IF((ItemData[Name]=A3)*(ItemData[CompletedDate]<=$B$1),VALUE(ItemData[CompletedDate])),0) array with CTRL + SHIFT + ENTER
I receive 1/0/1990.
I tried changing around the format of the date column, but I'm not sure what I am doing wrong to not show more.
Last edited: