+ Reply to Thread
Results 1 to 3 of 3

Spreadsheet showing Consecutive Mondays (and Dates) in a Year

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Spreadsheet showing Consecutive Mondays (and Dates) in a Year

    Hi all!

    New to Excel, and what its capable of, so here I am asking for help...

    Basically what I need to get done is create a spreadsheet that shows EACH and EVERY Monday (no other days of the week) in a year...from Jan 2, 2012 to Dec 31, 2012.

    I really have no idea where to begin so any help on how to do this would be greatly appreciated...Thanks!

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Spreadsheet showing Consecutive Mondays (and Dates) in a Year

    See the attached file.

    a2 =
    Please Login or Register  to view this content.
    and drag down
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Spreadsheet showing Consecutive Mondays (and Dates) in a Year

    Most years have 52 mondays, and sometimes 53
    The first monday in a year will be from 1-jan until 7-jan
    So this is my solution.....
    Attached Files Attached Files
    Kind regards,
    Piet Bom

+ 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