Results 1 to 3 of 3

Formula Only Once Date Triggers

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 365
    Posts
    63

    Formula Only Once Date Triggers

    Good morning,

    Im trying to write a formula that is based on multiple criteria that would allow me to show a monthly ramp of for the production of goods based on the first months start date. I’ve attached a workbook which shows the ramp up of production for the first three months and continuing at 100% capacity for months 4 and beyond. However, I want data in H5:S7 to trigger based on the start date of production in F5:F7. I’ve highlighted the data as it should populate in yellow.

    Is this possible?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel formula or dashboard creation for absence triggers
    By kmerton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2023, 06:54 AM
  2. Formula recalc triggers macro
    By paradocs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2020, 08:16 PM
  3. Entering date triggers subsequent entries automatically
    By dmunger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2016, 04:24 PM
  4. [SOLVED] Help with a VLookup Formula in Conditional Formatting, multiple triggers
    By szm187 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2016, 06:43 PM
  5. [SOLVED] Date triggers moving data to another aheet
    By bnwash in forum Excel General
    Replies: 5
    Last Post: 09-30-2014, 02:02 AM
  6. Date Triggers
    By trainer102 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2014, 07:48 AM
  7. Trying to change Row colours on field triggers - either date and or words
    By Redjessie1006 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-04-2013, 06:22 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