| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
A number of days into weeks and days
Hi
Taking date of the 5-8-2005 from 30-8-2005 then dividing the answer by 7 gives 3.571429.......weeks. How do you convert the decimal part of 0.571429 into number of days?. i.e. 4 Can an Excel formula give the correct answer of 3 weeks 4 days. -- Thank you Regards Aussie Bob C. Using Windows XP Home + Office 2003 Pro |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
| Calculating number of weeks from two dates | Excel Discussion (Misc queries) | |||
| How do I sort by date (not days, weeks, months) in Excel 2000? | Excel Discussion (Misc queries) | |||
| Need number of months or weeks passed from formula | Excel Worksheet Functions | |||
Threaded Mode
