counting weeks and days between dates
On Sep 26, 11:42 am, JW wrote:
Sorry. Left the =" off of the first way.
="Weeks: "&INT((C3-B3)/7)&" Days: "&(C3-B3)-INT((C3-B3)/7)*7
JW wrote:
One way:
Weeks: "&INT((C3-B3)/7)&" Days: "&(C3-B3)-INT((C3-B3)/7)*7
Another way:
="Weeks: "&INT(DATEDIF(B3,C3,"d")/7)&" Days: "&DATEDIF(B3,C3,"d")-
INT((C3-B3)/7)*7
wrote:
I need a formula that will give me the total number of weeks and days
between 2 dates. ie. b3=Apr-2,2001, c3=Oct.31,2001 what is the
total number of weeks and days between these dates.
I have the formula to get the number of weeks but have trouble getting
the number of days left to show.
I have so far: =INT((C3-B3)/7) to get the weeks.
When I count out the numbers, I get 3 calendar days left. But if I
simply use the total number of days between B3 and C3 less number of
weeks times 7 I get 2 days. It is out 1 day.
Any ideas on how to make it more accurate?
thx all
Mel- Hide quoted text -
- Show quoted text -
works great.
thx once again.
|