Thread: Date function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Date function
=INT((B2-A2)/7)&" weeks and "&MOD(B2-A2,7)&" days"
--
David Biddulph

"tsony" wrote in message
...
Is anybody knows how to deduct two dates and the result should be in
number
of weeks and days (eg. 26 days should be 3 weeks and 5 days)?


Reply With QuoteReply With Quote