+ Reply to Thread
Results 1 to 2 of 2

auto filling week and date fields based on another date value

  1. #1
    Registered User
    Join Date
    02-03-2021
    Location
    Northenr Ireland
    MS-Off Ver
    windows 10
    Posts
    1

    auto filling week and date fields based on another date value

    excel help.jpg

    Hi, for the above image file

    is there a way i can input date in column L that the week ending Colum can match that in terms of the end of that 7 day trading week aligned period (column H) and maybe also year ( column E)

    so this would mean if I say put in 2/6/20 or 5/6/20 it would give me a week ending value of 7/7/20 for both fields automatically.

    Thanks, Kind Regards

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,205

    Re: auto filling week and date fields based on another date value

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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. Auto Populate Date and Text based on calculated fields
    By tkelbel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-09-2020, 12:12 PM
  2. Auto allocation of week number based on date of completion
    By pearlite007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2017, 02:42 PM
  3. Dynamically Filling in Allocation in Months based only on Start Date and End Date
    By Computermoss in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2013, 01:16 PM
  4. Date Formula Help to auto populate next day of the week's date
    By symaxf in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-13-2010, 08:04 AM
  5. Filling cells with 3 different colors based on date in cell and todays date
    By chinookcrew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-23-2009, 07:36 AM
  6. week start date and end date based on week number
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 12:39 PM
  7. [SOLVED] Code for auto filling in Excel based on number of months, & start date
    By Diane Sulton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 09:20 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