Results 1 to 10 of 10

Automatically populate values into D3:D18 with dates from the calendar

Threaded View

  1. 09-19-2020, 10:30 AM #1
    newbie8
    newbie8 is offline
    Registered User
    Join Date
    09-19-2020
    Location
    melbourne
    MS-Off Ver
    2019
    Posts
    5

    Automatically populate values into D3:D18 with dates from the calendar

    I need help with some complex formula.

    I need to populate values into D3:D18 with dates from the calendar I had built on the right side.

    Each value in the calendar consist of W1, W2, W3.....W16.

    Thus, if any values selected in the calendar is 'W1', it will populate into the Week 1.

    W2 for Week2 and onwards.


    Excel1.jpg

    Excel2.jpg
    Attached Files Attached Files
    Last edited by AliGW; 09-19-2020 at 10:55 AM.
    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] Complex formula getting moer complex
    By Trebor777 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-02-2017, 01:39 PM
  2. Complex V Look up formula
    By excelconditional in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-20-2017, 11:43 AM
  3. Complex if formula
    By BROrion89 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2015, 05:36 PM
  4. [SOLVED] Use an existing cell formula for creating a new more complex formula
    By dubcap01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2014, 07:41 AM
  5. Looking for a help with a complex vertical and horizontal lookup... (complex to me!)
    By Nerhesi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2014, 12:47 AM
  6. [SOLVED] Complex if formula help
    By davisfs2007 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-15-2012, 03:14 PM
  7. Complex formula using IF THEN ELSE
    By daymaker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2011, 10:05 AM

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