View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default converting days into weeks

Hi I am trying to convert days into weeks and everythings fine until you
have
only 5 days showing, but this shows up as 0.7. The formula I am using is
D3/7 and i have also tried (D3-1)/7 and this shows 0.6.

Therfore could someone please what formula i need to show 0.5.


Are you saying you want the number after the decimal point to be the actual
number of days and not the actual fraction of a week that the number of days
represents?

Rick