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

Thread: Counting Weeks

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to count how many weeks are between a date and today's date.

    Cell G2 is 1/18/2001. In H3 is the forumla and the result of the amount of weeks.


    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you could use
    =(TODAY()-G2)/7

    and format as general.

    Or dress it up a little with something like:
    =INT((TODAY()-G2)/7)&" week(s)"&IF(MOD(TODAY()-G2,7),", "&MOD(TODAY()-G2,7)&" day(s)"," exactly")


    good luck

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks a lot.
    That worked perfectly!

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
  •