Posted to microsoft.public.excel.worksheet.functions
|
|
converting days into weeks
chedd 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.Therfore could someone please what formula i need to show 0.5.
--
Message posted via http://www.officekb.com
|