Page 1 of Any bored Excel wizzkids fancy a little challenge?

I need to create a static date/timestamp in a cell every time another cell has something typed into it. This is fairly straightforward in Excel using the NOW() function and forcing a circular reference so that it doesn`t keep updating the date/time each time the spreadsheet is refreshed:

=IF(A<>"",IF(B="",NOW(),B)"") 

(iterations have been enabled in Excel meaning that when the cell keeps referring back to itself it doesn`t error and after a number of attempts it just displays the current value of the cell)

The trouble is, this syncs up with a Documents to Go spreadsheet on my phone which does not support circular references.

Is there another way of doing this without the circular reference?

(if this is gobbledygook to you, *respectfully* you are perhaps not the right person for the job...)

You have brought back horrible memories of Spreadsheet Formulas.

EASY SOLUTION.....I used to get the secretary to do it, as she had learned a lot at night school :D

Good luck sorting it out.

Alas, I don`t have a spreadsheet-ninja-secretary, or indeed, a secretary.

You have a ninja though?



"Talking`s for lesbians" Psycho Paul 2011.

I ate my last ninja yesterday. None left.