+ Reply to Thread
Results 1 to 5 of 5

weekly date range

  1. #1
    Forum Contributor
    Join Date
    06-17-2013
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    247

    weekly date range

    Hi All,

    So i need to track something for the week on a monthly tracker... is there anything i can use in excel to identify the current networkday daterange..

    E.g so this week would be 17/03/14-21/03/14 and is the same formula so next week it will change the date range to 24/03/14-28/03/14 etc?

  2. #2
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    170

    Re: weekly date range

    This will always identify the most recent Monday.

    =(TODAY()-(WEEKDAY(TODAY(),2))+1)

    You can then have a second cell with that +4 to show the Friday.

    That's the closest I can think of. If you return both the Monday to Friday reference in one cell (using =(TODAY()-(WEEKDAY(TODAY(),2))+1)&" - "&(TODAY()-(WEEKDAY(TODAY(),2))+5) it returns an Excel date reference (ie 41715 - 41719)
    Last edited by cffndncr; 03-18-2014 at 09:08 PM.

  3. #3
    Forum Contributor
    Join Date
    06-17-2013
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    247

    Re: weekly date range

    awesome, this will work to give me a result i can use! :D and this will update every monday by the looks of it!

    you are an absolute legend... words cannot describe how greatful i am! haha cheers!!

  4. #4
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    170

    Re: weekly date range

    Should update every day, as the TODAY() and weekday() formulas depend on today's date

  5. #5
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    170

    Re: weekly date range

    Also, if this solves your problem, please mark the thread as [SOLVED]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Counting figures that fall withing a weekly date range
    By sam-1890 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2012, 06:58 AM
  2. Replies: 10
    Last Post: 05-11-2012, 02:14 AM
  3. Replies: 7
    Last Post: 11-16-2008, 05:48 PM
  4. Date Range -- Weekly
    By Brad Payne in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2005, 07:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1