+ Reply to Thread
Results 1 to 5 of 5

Formula/Macro to list down the dates that are inside a week number of a month

  1. 11-22-2014, 05:15 AM #1
    michaljireht
    michaljireht is offline
    Registered User
    Join Date
    11-26-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2013
    Posts
    21

    Question Formula/Macro to list down the dates that are inside a week number of a month

    Good day, all.

    I need a formula/code that will list down all the dates within a given week of a given month.

    For example:

    Year 2014
    Month November
    Week 1
    Dates:
    11/3/2014
    11/4/2014
    11/5/2014
    11/6/2014
    11/7/2014
    11/8/2014
    11/9/2014

    Thank you for your time!
    Reply With QuoteRegister To Reply
  2. 11-22-2014, 06:07 AM #2
    Crooza
    Crooza is offline
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Formula/Macro to list down the dates that are inside a week number of a month

    try thi formula

    Please Login or Register  to view this content.
    and here it is in a spreadsheet

    weeknumber.xlsx
    Happy with my advice? Click on the * reputation button below
    Reply With QuoteRegister To Reply
  3. 11-22-2014, 06:22 AM #3
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formula/Macro to list down the dates that are inside a week number of a month

    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  4. 11-22-2014, 06:38 AM #4
    Crooza
    Crooza is offline
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Formula/Macro to list down the dates that are inside a week number of a month

    A quick edit

    use this formula instead

    Please Login or Register  to view this content.
    Last edited by Crooza; 11-22-2014 at 06:41 AM.
    Reply With QuoteRegister To Reply
  5. 11-22-2014, 08:16 AM #5
    michaljireht
    michaljireht is offline
    Registered User
    Join Date
    11-26-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2013
    Posts
    21

    Re: Formula/Macro to list down the dates that are inside a week number of a month

    Wow, there are awesome. Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Diaply week number from list of dates
    By john dalton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-19-2013, 04:44 PM
  2. Counting number of unique dates per month in a list of duplicate dates
    By Rackle83 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2013, 10:15 AM
  3. Formula for Week number within a fiscal month
    By GerryT in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2012, 08:14 PM
  4. List of Dates- Assign Week Number??
    By Micquia in forum Excel General
    Replies: 1
    Last Post: 07-11-2006, 05:05 PM
  5. Formula for a date's week number in a month (1st, 2nd, etc.)
    By Charles in forum Excel General
    Replies: 1
    Last Post: 03-10-2006, 05:15 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