| 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 |
|
#2
|
|||
|
|||
|
=INT((H1-G1)/7)&" weeks"&IF(MOD(H1-G1,7)=0,"",", "&MOD(H1-G1,7)&" days")
-- HTH RP (remove nothere from the email address if mailing direct) "Robert Christie" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
=INT(3.571429)
will give you 3 weeks =(3.571429-INT(3.571429))*7 will give you 4 days Replace 3.571429 with your formula Mangesh "Robert Christie" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
=mod(enddate - startsdate,7) will give the number of days. so =INT((enddate-startdate)/7)&" weeks "&MOD(enddate-startdate,7)&" days" returns 3 weeks 4 days -- Alex Delamain ------------------------------------------------------------------------ Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273 View this thread: http://www.excelforum.com/showthread...hreadid=400393 |
|
#5
|
|||
|
|||
|
Thank you Bob, Mangesh and Alex for your quick replies.
-- Thank you Regards Aussie Bob C. Using Windows XP Home + Office 2003 Pro "Bob Phillips" wrote: =INT((H1-G1)/7)&" weeks"&IF(MOD(H1-G1,7)=0,"",", "&MOD(H1-G1,7)&" days") -- HTH RP (remove nothere from the email address if mailing direct) "Robert Christie" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
