| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting days into weeks | Excel Worksheet Functions | |||
| Weeks and days sorting out | 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
