+ Reply to Thread
Results 1 to 2 of 2

Trying to create a formula to show the first date when there is data available

  1. #1
    Registered User
    Join Date
    08-05-2020
    Location
    new york
    MS-Off Ver
    office for mac
    Posts
    1

    Trying to create a formula to show the first date when there is data available

    Hello,

    I'm trying to create a formula to show the first date when there is data available. So there is data for each episode title listed out by day (9/19/19 thru 6/20/20). Each episode title has data during this time frame.

    For "Madea Christmas" ("Sample" tab), the first date of data is 11/21. I'm trying to fill in column D with that first date where data was available.

    Attached is the sample excel file. Thank you!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    754

    Re: Trying to create a formula to show the first date when there is data available

    You can indicate the expected results ?

+ 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. [SOLVED] Create a today bar that will refresh to show the current date
    By anderem12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2020, 04:30 PM
  2. Create formula to show last value of changing cells
    By DavidRoger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2019, 08:55 AM
  3. [SOLVED] Formula to show Date(s) of when 2digts out of 3 digits show up in Cell(s)
    By Brian.Aerojet in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 04-24-2019, 09:04 PM
  4. Replies: 1
    Last Post: 10-04-2013, 02:58 PM
  5. How to create a formula to show sum?
    By jolyim in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2012, 03:06 PM
  6. Date formula if positive show, if negative don't show.
    By Cyberpawz in forum Excel General
    Replies: 8
    Last Post: 03-14-2012, 07:49 AM
  7. [SOLVED] How do I create autosum formula to show totals for visible data on
    By NickCr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2006, 12:15 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