can we sort two column simultaneously

[Shano1989]

I have an excel where column E and F are sorted each column, however, I want column E & F to be sorted simultaneously so that both column dates are in sequential ascending order. I have attached one excel with the current issue and the proposed result

[#2]

@Shano1989 Not in one go. That's just not how it works. but you can add a column summing the dates in E and F. This creates one column of dates which you can then sort from Oldest to Newest. 

If both E and F can hold dates and you want the latest of the two to determine the sort order us a formula like =MAX(E4,F4) or =MIN(E4,F4) in case it should be the earliest of the two.

[#3]

@Shano1989 

Add a column:

=SUM(E4:F4)

Sort by that column.