| Home |
| Search |
| Today's Posts |
|
#1
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. -- Message posted via http://www.officekb.com |
| 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
