Genius Geoff!!! Pure and Simple!!!
for you!!!
But this can also be done w/o having to format the cell (i.e. it can be left at "General"

:
To get the number of days
=VALUE(TEXT((NOW()-$A$1)/24,"[h]"

)
To get the number of weeks
=VALUE(TEXT((NOW()-$A$1)/168,"[h]"

)
Plus this can also be taken further to get the exact number of days (w/ decimal) by using "[h].m" format!
To get the exact number of days (w/ hours as a decimal)
=VALUE(TEXT((NOW()-$A$1)/24,"[h].m"

)
To get the exact number of weeks (w/ days as a decimal)
=VALUE(TEXT((NOW()-$A$1)/168,"[h].m"

)
This works with days and weeks because 1 day = 24 hours and 1 week = 168 hours. Unfortunately the months have various number of days and there is a leap year. But I'm sure that with a couple of nested if's you could get it to work for months and years too!!
I think I will add this to my FAQ: faq68-4037 - What are some of Excel's date functions?
Peace!
Mike
Never say Never!!!
Nothing is impossible!!!