On Fri, 20 Feb 2009 16:59:01 -0800, da wrote:

Thanks, but how and where do I write these formulas?

You put them in the cell where you want to see the relevant data.

If your original is in A1, and you want to see the date in B1, then you would
put the formula I provided for the date in B1. And so forth.

Please note that if your original data is NOT in A1, you will need to change
the reference to A1 in the formulas I provided to reflect the correct cell.
--ron