Try this
=INT(DATEDIF(A1,B1,"d")/7) &" Weeks " &MOD(DATEDIF(A1,B1,"d"),7) & " Days"
Note that DATEDIF isn't documented in Excel so for help look here
http://www.cpearson.com/excel/datedif.htm
Mike
"moshe" wrote:
when i enter a date in A1 and another date in B1, i want that in C1 should
calculate the days,
EX: if the dates are from 02/10/09 - 02/20/09, it should be written 1 week
and 3 days, (not 10 days)
--
mf