| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weeks and days sorting out | Excel Discussion (Misc queries) | |||
| minutes seconds days weeks years | Excel Discussion (Misc queries) | |||
| Converting Dates to Weeks | Excel Worksheet Functions | |||
| How to calculate in weeks and days? | Excel Discussion (Misc queries) | |||
| A number of days into weeks and days | Excel Worksheet Functions | |||
Threaded Mode
