Calculating Days between dates

**Jenson** · 05-21-2005, 12:14 PM

I have a date which I'm trying to calculate total number of days to the current date, but the date is in an uncommon format.

20030822
So the above number is in the yyyymmdd format. I have an entire column of numbers like these. How would I calculate how many days are there from that time to now?

**olasa** · 05-21-2005, 12:20 PM

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