Selecting A Cell Which Changes Fornightly 1

[sprog]

I have a report which is updated fortnightly with a new column of information.

How do I tell a particular cell to read a row in the last column of information.

eg: This fornight it will read cell D5 and next fornight it will need to read cell E5, then next fortnight, cell F5 etc. etc.

Any help would be appreciated.

Thanks

 

[Zathras]

Some variation of this formula should do the trick:
[blue]

  =INDIRECT(ADDRESS(5,INT((TODAY()-37896)/14)+4))

[/color]
The number 5 represents the fifth row.
The number 37896 represents 2 October 2003.
The number 14 represents the number of days in a fortnight.
Then number 4 represents the fourth column as the initial column.

You need to adjust the day number (37896) up or down so that it becomes the correct reference point where the fortnights roll over. Once you get it synchronized it should give you exactly what you asked for.

 

[sprog]

Thank you very much. This worked perfectly with a little change.

Much appreciated.