count of weeks between two dates

[Access Beginner]

Hi,

I found this formula on the internet, which counts the number of weeks between two dates. =INT((F5-D5)/7)

Is there a formula that will display 10.3 weeks if it is 10 weeks and 3 days between the two dates?

Any help is appreciated.

Cheers

 

[par60056]

The int lops off the remaining days.

A decimal would not be right in that it is not 30% of a week. but 3 days is 42% of a week.

The more correct answer would be to just remove the INT

But if you Really want it, try
==INT((F5-D5)/7)+MOD(((F5-D5)/7),1)*7/10

 

[MARK858]

with all the normal caveats to do with datedif.... formatted as mm.dd

Excel Workbook
	A	B	C	D
1	01/02/2013	01/03/2013	*	01.00
2	01/02/2013	02/03/2013	*	01.01
3	01/02/2013	03/03/2013	*	01.02
Sheet2

 

[Access Beginner]

Thanks for that, much appreciated.

 

[par60056]

Mark, I think they wanted weeks and days not months and days

 

[MARK858]

par60056, Yep, you are perfectly correct.

 

[MARK858]

Weeks and days this time (only it is text)

Excel Workbook
	A	B	C
1	01/02/2013	01/03/2013	4.0
2	01/02/2013	02/03/2013	4.1
3	01/02/2013	03/03/2013	4.2
Sheet2

 

[Access Beginner]

thanks guys a couple of options to choose from

Cheers again