View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Edward Edward is offline
external usenet poster
 
Posts: 34
Default converting days into weeks

On May 23, 9:07 am, "chedd via OfficeKB.com" <u18187@uwe wrote:
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.


It would be easier to answer your question if you asked one.