Results 1 to 9 of 9

Get First day of the Month and every Monday of the succeeding weeks within that month

Threaded View

  1. 08-13-2018, 07:07 AM #7
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Get First day of the Month and every Monday of the succeeding weeks within that month

    Try this. In D2 then drag down.

    =MAX(B2-WEEKDAY(B2,2)+1,EOMONTH(B2,-1)+1)
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find First Monday of the Month
    By Anarchus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2016, 04:33 AM
  2. 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
  3. [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
  4. [SOLVED] calculating number of weeks in a month ( jan -Dec 13) starting every monday+display
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2013, 10:01 AM
  5. Excel 2007 : Timeline month/days to month/weeks?
    By Bellaggio1770 in forum Excel General
    Replies: 12
    Last Post: 04-14-2012, 05:09 PM
  6. [SOLVED] Calculating first/last Monday, Tuesday, etc. in a given month in E
    By Rossta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2006, 09:25 PM
  7. need to work out if a monday is the 1st 2nd 3rd or 4th monday of a month
    By Stuart Gillingh in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1