PC Review


Reply
Thread Tools Rate Thread

how can i determine number of weeks between 2 dates

 
 
amanda
Guest
Posts: n/a
 
      1st Jul 2008

 
Reply With Quote
 
 
 
 
Sandy Mann
Guest
Posts: n/a
 
      1st Jul 2008
=INT((A2-A1)/7)

Where A2 is the later date

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"amanda" <(E-Mail Removed)> wrote in message
newsBA54D31-7737-42A6-84D3-(E-Mail Removed)...
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine the number of weeks at this moment? Eric Microsoft Excel Misc 2 15th Sep 2008 09:33 PM
determine number of weeks between 2 date with decimal Question Boy Microsoft Access Queries 1 25th Apr 2008 12:08 AM
Calculating number of weeks between dates (start and end dates) =?Utf-8?B?R2VyYWxkIExlbWF5?= Microsoft Excel Discussion 1 28th Mar 2007 01:13 PM
HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE . =?Utf-8?B?V0FSUkVOQ0hFUllM?= Microsoft Excel Worksheet Functions 1 5th Jan 2005 08:15 AM
Number of Weeks between two dates ibeetb Microsoft Excel Worksheet Functions 2 26th Sep 2003 07:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:54 PM.