Forum Discussion

Riaan1055's avatar
Riaan1055
Copper Contributor
Mar 20, 2020

Excel - formual

Hi guys I want to if it's possible for excel to automatically update data. For example: I have a table of dates, 1st till end of month. I want it to keep on showing the current dates data. Like ...
BI & Data Analysis
excel
Formulas and Functions
Savia's avatar
Savia
Steel Contributor
Mar 20, 2020

Riaan1055 Your question is pretty generic, but one thing to look in to is the TODAY() function, which automatically computes the present date.  This could be used in a filter column e.g. =datecell=TODAY() to zero in on today's data.

 

And more detail than that, I'd really need to see a screenshot or a file.

  • Riaan1055's avatar
    Riaan1055
    Copper Contributor
    Mar 24, 2020
    Hi Savia, here is an example of the sheet. As you may see in the bottom row 48, column M. I need that percentage to uodate automatically in row 61, column W.
    So let's say today is the 24th, I need it to update to the current date, but when it is tomorrow, i need it to put in that data.

    Thanks
    • Savia's avatar
      Savia
      Steel Contributor
      Mar 24, 2020

      Riaan1055 This image doesn't include the row/column headers so I can't really follow.  Could you attach a version of the file with dummy data or otherwise explain what the formulas here are doing?

  • Riaan1055's avatar
    Riaan1055
    Copper Contributor
    Mar 22, 2020
    Hi Savia

    I'll post the screenshots during the day. Thanks a lot

Resources