+ Reply to Thread
Results 1 to 3 of 3

Formula revealing # of days b/t dates that will read future data (inserted by macros)

  1. #1
    Registered User
    Join Date
    03-21-2019
    Location
    Windsor, PA
    MS-Off Ver
    2016
    Posts
    2

    Cool Formula revealing # of days b/t dates that will read future data (inserted by macros)

    I have a Master Data sheet that stores all data from my bakery. In the same workbook, I have a Copy Data Here Page where I insert the excel file downloaded from our Point of Sale system and after running the macro, it converts it all into the right format and drops it in the Master Data Page. I also have a Sum Page in this workbook that I want to read a variety of summarized data (by manually inserting a start date and end date in cells A3 (Start Date) & B3 (End Date)). The first thing that I would like to summarize is the # of days between the dates entered on Sum Page C3. For instance, if start date is January 10, 2019 & end date is January 11, 2019, the answer would be 2 days. All the dates are in Column C of the Master Data Worksheet. There are two dilemmas: first, there is a date assigned to every item sold which means that if I sold 10 pies on January 10, 2019, Column C will have 10 dates of January 10,2019. The second problem, is that I do not want to have update the formula every time new data is inserted into the Master Data page from the macro. I would like a formula which handles all these problems. Help would be appreciated. Thanks!

  2. #2
    Forum Contributor
    Join Date
    08-30-2007
    Location
    Vancouver, B.C.
    Posts
    149

    Re: Formula revealing # of days b/t dates that will read future data (inserted by macros)

    There are many ways to approach your problem but I don't see you posted a specific formula question for us to help.

    Try adding a Pivot table to your data and explore its functions. Every time you have new data added, all you have to do is refresh your Pivot table.

  3. #3
    Registered User
    Join Date
    03-21-2019
    Location
    Windsor, PA
    MS-Off Ver
    2016
    Posts
    2

    Re: Formula revealing # of days b/t dates that will read future data (inserted by macros)

    The formula I need will need to calculate the # of unique dates between 2 dates on a different sheet and be able to read new data as inserted.

+ 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. Formula that predicts a future date of payment based on an average # of days.
    By littlewing52 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-07-2017, 05:32 PM
  2. [SOLVED] Get rid of 1/5/1900 in my column with a formula to calculate 5 days into the future
    By jholiday78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2014, 12:43 PM
  3. A Schedule with Planned, Actual, Days +/- and Future Dates
    By jm90045 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-28-2013, 08:16 PM
  4. Hide Future Rows Containing Future Dates.
    By Raj_121 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 07:14 AM
  5. Filter by various dates 30, 60, 90 days in the future
    By sandiegobeach in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-21-2012, 09:18 PM
  6. Determine future dates based on selected days of the week
    By hnowack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2008, 09:51 PM
  7. how to calculate dates that are 30 & 60 days in the future...
    By marcusp2001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2008, 09:21 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