+ Reply to Thread
Results 1 to 4 of 4

Automatic week commencing date

  1. #1
    Registered User
    Join Date
    12-15-2011
    Location
    Warrington
    MS-Off Ver
    Excel 2003
    Posts
    2

    Automatic week commencing date

    Hi

    I need help having an automatic week commencing date (from Monday) in cell A1

    The date needs to be correct each time the workbook is opened.

    Let me know if you need any more info.

    Thanks for your help

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Automatic week commencing date

    In A1 enter =TODAY()-WEEKDAY(TODAY(),2)+1 to obtain first Monday of current week

  3. #3
    Registered User
    Join Date
    12-15-2011
    Location
    Warrington
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Automatic week commencing date

    Thanks. working now

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Automatic week commencing date

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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