How do i automatically sort dates in a row and then run those dates through a function?

Hello Everyone,

Any help would be appreciated!

I have 2 tables, of relative dates. Here is the table


Table1 Table2
Exam1 Exam 2 Exam 3 Result1 Result2


Both the tables hold only dates
1) Only one exam can be held on any single date.
2) Up to 3 Exams can be held before a single Result is Declared but no more.
3) The Result of an exam is declared after 18 days.
4) The Results should be in the order that the Exams are held in.

So i want to be able to enter all Exam dates in Table1 and have the respective Result Dates calculated in Table2.


Thank You

Hi,
1) consider attaching a file as described in (read whole): http://www.excelforum.com/forum-rule...rum-rules.html
2) I wonder why you posted it in http://www.excelforum.com/excel-charting-and-pivots/ and not for instance in http://www.excelforum.com/excel-general/