Results 1 to 8 of 8

Extract date range from cell and populate 'calendar-style' in separate tab

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2019
    Location
    NSW, Australia
    MS-Off Ver
    MS Office Professional 2016
    Posts
    3

    Question Extract date range from cell and populate 'calendar-style' in separate tab

    I would like to extract a start date (e.g. 1/1/19) and duration (e.g. 10 days) from a single cell to a separate tab that is set up like a calendar (1 row to a day from 1 January onwards). Is it possible to get the date range to fill the 10 rows for 1-10 January?

    File attached - this particular spreadsheet tracks the number of days a contractor is at a commercial jobsite. For example, John Smith is at Jobsite A 1-10 January. On the Construction Planner tab, I have the dates in the first column for 1 January onwards, each day to a row. I would like the date data in Client Planner tab to populate across to fill John Smith's column for 1-10 January.

    Tough ask but I thought I would start here to see if anyone knew if something like this is possible! Thanks in advance
    Attached Files Attached Files
    Last edited by ammegrace; 01-19-2019 at 09:16 PM. Reason: Adding attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-11-2019, 09:05 PM
  2. [SOLVED] Extract data from tables and populate a separate table?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-20-2017, 03:08 PM
  3. convert 360 calendar integers to normal calendar style dates
    By dmhg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-03-2014, 08:17 PM
  4. Populate an Excel calendar template with events from a separate table
    By Dana_Carter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2014, 12:14 PM
  5. Populate a specific range based on calendar date
    By gottnoskill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2014, 03:19 PM
  6. Need a calendar plug in, to help populate a cell with date
    By RCC in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2006, 12:35 PM
  7. [SOLVED] Populate a cell with a date using calendar pick
    By Shane Nation in forum Excel General
    Replies: 2
    Last Post: 01-29-2006, 03:50 PM

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