Sort/Shuffle Certain columns for a given row

[Athenia413]

I feel like this should be somewhat simple, but none of the normal methods I know seem to work. I want to set up a formula (not a basic sort, since I want it to automatically correct every time I change information) so that for each row, several columns re-sort by date.

For instance, I have the following table:

Item Type Dates

A DV 5/2/14 6/12/14 7/11/15
B DS 3/11/13 6/19/14 1/2/15
C LG 11/12/14 8/1/15 1/12/16
...

where each of the dates is in a new column, but the "Dates" title is merged between the cells

I want to be able to resort just the date columns(/cells) for each row if a new date is written. I want the dates to be in ascending order. For instance, if I go back into the worksheet and replace Item A's date 5/2/14 with 1/1/16, I want the date columns JUST FOR Item A to reshuffle/resort to be:

A DV 6/12/14 7/11/15 1/1/16


without it resorting any other rows (Items) columns.

[shg]

An automatic sort can't be performed by formula unless the results are to appear somewhere else. If can be done via VBA in the Sheet module:

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[Athenia413]

Thanks. That is probably a little more than I really want to do for this. Is there a way to calculate a statement using days of the week? In this case, some similar to a nearest integer function for days instead of numbers? I want a mark to appear if the date in a cell is less than two tuesdays from today. I usually check on Sundays, so at the moment, I have TODAY()+9, but I would prefer the sheet to work everyday.

This is the current formula I have:

=IF(OR((AND(D3<TODAY()+9,NOT(ISBLANK(D3)))),AND(E3<TODAY()+9,NOT(ISBLANK(E3))),AND(F3<TODAY()+9,NOT(ISBLANK(F3))),AND(G3<TODAY()+9,NOT(ISBLANK(G3)))),"*"," ")

[shg]

How does that relate to your original question about sorting?

[Athenia413]

I was originally trying to make it easier to see when a rows date was coming up by reshuffling the dates in order. Two Tuesdays from whatever day it is is the important date. I figure it will be just as noticeable (if not more so) just to basically check the side of a row when the date is coming up.