+ Reply to Thread
Results 1 to 12 of 12

Auto-fill dates based on input in other cells

Hybrid View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,029

    Re: Auto-fill dates based on input in other cells

    All you have to do is copy those formulae down for the other rows. If you can't work it out, attach your workbook and one of us will show you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  2. #2
    Registered User
    Join Date
    03-27-2018
    Location
    Tennessee, USA
    MS-Off Ver
    Office 2013
    Posts
    6

    Re: Auto-fill dates based on input in other cells

    Copying formulae is okay, but is there a way to auto-populate the data? for example, if I insert the final date and close out date, the due date and reminders 1-3 will auto general based on a pre-determined formula?


    Attached is a sample of my data sets. If you can't see the attachement, please let me know.
    Attached Files Attached Files

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,029

    Re: Auto-fill dates based on input in other cells

    Sorry, looking at your sheet I am not clear on the calculations that you want to happen automatically? Can you explain what happens in each of the four cases, please?

+ 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-fill based on input
    By BigPaulMc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2015, 07:22 PM
  2. Help with auto fill cells based on two cell input.
    By Osros in forum Excel General
    Replies: 0
    Last Post: 07-07-2014, 07:30 PM
  3. Help to create Macro to Auto-fill end of month based on given start and end dates
    By patidallas22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2014, 11:26 AM
  4. Auto Fill Cells With Dates
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2013, 11:27 AM
  5. Auto-fill cells with Dates based on another date cell
    By oneilkr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2013, 07:32 PM
  6. Automatically Fill Adjacent Cells Based On Input Data
    By maxraph in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2012, 01:04 PM
  7. Replies: 1
    Last Post: 05-27-2010, 12:32 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