+ 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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,379

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,379

    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