Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Looking for ideas

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I test for the number of weeks between two cells that contain dates? I have the date 2/27/02 in cell "b5" and the date 3/27/02 in cell "A1", how can write a formula to take the number of days between those two cells and divide by 7 to give me a number of weeks?
    I appreciate the help from everyone at Mr. Excel.

    viper

  2. #2
    Guest

    Default

    =(A1-B5)/7

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks,

    Just wasn't thinking about a simple formula, thought I needed something more but it worked great.

    Thanks again,
    I appreciate the help from everyone at Mr. Excel.

    viper

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •