Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2008, 03:04 AM
leroytrolley leroytrolley is offline
Novice
Counting Weeks
 
Join Date: Jul 2008
Posts: 11
leroytrolley is on a distinguished road
Default Counting Weeks

Can anybody tell me how I can solve this problem.

I need to enter two different dates and ask excel to work out how many weeks have passed between the two weeks.

i.e. how many weeks have passed between 14/10/2007 and 06/04/2008.

Cheers
Reply With Quote
  #2  
Old 08-18-2008, 11:12 AM
Onihonker Onihonker is offline
Novice
 
Join Date: Aug 2008
Posts: 8
Onihonker is on a distinguished road
Default

Quote:
Originally Posted by leroytrolley View Post
Can anybody tell me how I can solve this problem.

I need to enter two different dates and ask excel to work out how many weeks have passed between the two weeks.

i.e. how many weeks have passed between 14/10/2007 and 06/04/2008.

Cheers
I made an excel week calculator. Below you will find how I labeled my cells in my table complete with example information on the right hand side.

Here in my example my spreadsheet calculates the weekly difference between January 1 '08 and January 22 '08.
Week Calculator *no pun intended
Last Date 1/22/2008
First Date 1/1/2008
Difference in number of weeks between Last Date and First Date
3.00

I suggest you look up the WEEKNUM function. If you are still unable to find an answer please post what you have found so far. Use it to calculate your weekly difference.

If you are unable to find a solution please post what you have found so far.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Legal Words bulletrick Word 0 12-30-2005 03:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft