Forum Discussion
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 ...
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.
Hi Savia
I'll post the screenshots during the day. Thanks a lot
I'll post the screenshots during the day. Thanks a lot