Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cyp010905
 
Posts: n/a
Default WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES

I want to creat a formula that will work out the number of weeks between two
dates but i can only find formulas for days or months . can anyone help
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES

One way:

A1: <start date
A2: <end date
A3: =(A2 - A1)/7

In article ,
cyp010905 wrote:

I want to creat a formula that will work out the number of weeks between two
dates but i can only find formulas for days or months . can anyone help

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to calculate number of days between Dates themax16 Excel Worksheet Functions 2 October 21st 05 01:38 PM
convert dates to number of days milk0s Excel Worksheet Functions 2 September 28th 05 01:31 PM
Need number of Saturdays and number of Sundays between 2 dates Class316 Excel Worksheet Functions 1 June 10th 05 02:47 AM
How do you calculate number of workdays from dates entered? [email protected] Excel Worksheet Functions 0 March 25th 05 08:55 PM
HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE . WARRENCHERYL Excel Worksheet Functions 1 January 5th 05 09:15 AM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"