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
|