LinkBack URL
About LinkBacks
This is one option:
Put this formula in the B Column, Format the column as General (not Date).
=TODAY()-DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
Hope it helps
Ola Sandström
This is one option:
Put this formula in the B Column, Format the column as General (not Date).
=TODAY()-DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
Hope it helps
Ola Sandström
Last edited by olasa; 05-21-2005 at 12:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks