+ Reply to Thread
Results 1 to 2 of 2

Return day number, knowing day of week, weeknum, month and year

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    42

    Return day number, knowing day of week, weeknum, month and year

    Hi all, and HNY!

    Another new-year hours-tracker request I'm afraid...

    Right, I've got a workbook in which the following is listed:

    The year
    The day of the week (in format "Monday, Tuesday", etc.)
    The week number (1-52)
    The month (in format "January, February", etc.)

    I've got a cell for each day of the week. I'd like to auto-populate this with the number of the day in each month, i.e. 1 for the 1st of each month, etc, not 1-365.

    I've had a go and just can't get my head around it.

    Sheet is attached. The cells I want to populate are highlighted in orange.

    Mega-thanks in advance, and I hope 2019's good to everyone!
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Return day number, knowing day of week, weeknum, month and year

    In cell C4, enter:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Copy to all orange cells.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. [SOLVED] Macro to get month of year and week number
    By I need excel help in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2018, 07:17 PM
  2. SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR
    By faodavid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-30-2017, 02:53 PM
  3. Return Value to Month-Year and Week Number
    By bambino86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2017, 12:59 AM
  4. [SOLVED] How do return days,week no,month and year in between two dates
    By silambarasan.J in forum Excel General
    Replies: 5
    Last Post: 10-26-2016, 04:29 AM
  5. Return averages based on day, week, month and year, from dates in column.
    By koalamotorsport in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2016, 11:11 PM
  6. [SOLVED] Calculate Week Range from Week Number, Month and Year?
    By A108A108 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-07-2016, 03:11 PM
  7. Return value of the last week of the month based on the year and month
    By stevekho2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-14-2013, 11:04 AM

Tags for this Thread

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