+ Reply to Thread
Results 1 to 4 of 4

Find First Monday of the Month

  1. #1
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    Find First Monday of the Month

    Hi there,

    I need to find the first Monday of each month, but also back date the other dates from the previous month I guess.

    I want to type in the first day of the month in cell A6 and then the dates appear below it in order of day.

    Start date:
    Wednesday, 1st January

    Results:
    Monday:
    Monday, 30th December

    Tuesday:
    Tuesday, 31st December

    Wedesday:
    Wednesday, 1st January

    Thursday:
    Thursday, 2nd January

    Friday:
    Friday, 3rd January

    I know what to do after this point for the rest of the month, it's just the first few cells i'm not sure how to type a formula.

    Basically, cell A7 would always be a Monday, A8 always be a Tuesday and so on, so even if the start of the month starts at the end of the week, I want the dates for the previous month also appear starting from the start of the week.

    Thanks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Find First Monday of the Month

    With your starting date in A6, this in A7:

    =A6-WEEKDAY(A6,2)+1

    and this in A8 copied down:

    =A7+1
    Last edited by AliGW; 12-06-2016 at 02:19 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    Re: Find First Monday of the Month

    Thank you, just what i wanted!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Find First Monday of the Month

    You're welcome!

+ 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. VBA Program that returns the first monday of a month
    By Taoyuan00 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2016, 08:46 AM
  2. [SOLVED] First day of month falls on a Monday VBA issue
    By af25 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-10-2014, 07:24 PM
  3. Find every Monday in a month using VBA
    By EmmaO91 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2014, 07:32 AM
  4. [SOLVED] Sum from the last Monday of the month previous
    By Berna11 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-17-2013, 03:26 PM
  5. Replies: 0
    Last Post: 02-20-2012, 02:27 PM
  6. Formula to recognise first monday of the month
    By Jonsocks in forum Excel General
    Replies: 8
    Last Post: 09-30-2010, 08:59 AM
  7. Replies: 1
    Last Post: 04-13-2005, 06:35 PM

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